Combining Excel-files from SharePoint causing DataSource.Error (_api/contextinfo)

[Anonymous]

Hi,

I have a model that retrieves data (Excel and PDF) from SharePoint. One of the data sources is based on daily Excel-'snapshots' with three columns and about 100 rows which is sent to me by mail. I use Microsoft Flow to save the attachments to SharePoint, and then use the combine-function in Power BI to append the files into one table. This has worked perfectly up to this week!

The number of files have reached 160 (and will continue to increase each day). When I now refresh the data, I receive two different errors (please see below). 

If I restart my pc and reduce the number of files in SharePoint the refresh works better (even though the error sometimes occurs - usually the first one). This maybe suggesting a memory issue since Power BI needs to open and load data from all the files? 

I have tried to use incremental refresh without any luck. The Excel-files does not include tables which exclude appending by MS Flow.

Have someone any ideas how to tackle this issue?

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

Based on my test, I cannot reproduce your issue here. I recommend you to create a support ticket for help if you are a pro user.

https://powerbi.microsoft.com/en-us/support/