Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi,
Just seeking some troubleshooting advice and whether this is something that we definitely need to refer to MS support.
We have a report published to the Service in a workspace on Premium capacity.
It has a daily refresh schedule.
The report uses some SharePoint file and folder datasources connecting to excel files in our SharePoint Online tenant without a gateway i.e. "cloud" data sources. The same data sources are in use whether in the Service or in Desktop.
The scheduled refresh started failing (on May 1).
The report had not been re-published.
The underlying data sources had not been changed (as far as we could tell)
Our main barriers to getting any traction on this problem are:
For example the most recent failures have had the following messages (note some file paths removed for security reasons) :
We have tried the following as part of troubleshooting with no resolution:
Does anyone thoughts on potential root causes or further troubleshooting steps we have not tried ? Something we have
Or should we just refer this to MS support ?
Thanks
Solved! Go to Solution.
I just checked the support page and there seems to be an issue with Premium workspaces that have SharePoint Online as a datasource.
Please check back on that page for a solution or workaround, and maybe you could still also file a support ticket. It might help solve the issue faster.
In case it may help anyone: We had exactly the same issue. Power BI was connected to several files on sharepoint using basically only two types of connector (1. Sharepoint file connector and, 2. Sharepoint folder connector). One to connect directly to files, and other to merge similar files we stored in sharepoint folders. Suddenly the refresh started failing. We received this idb command interface error message pointing to random tables in our data in every load attempt. After several months discussing with power bi and sharepoint support teams we discovered what the issue was. Basically, sharepoint has a limitation of maximum paralel access to data stored in it. On PBI desktop one is able to turn off parallel loading of tables, whereas in PBI server there is no such configuration. This means that queries created on PBI desktop accessing files on sharepoint will not always work on server. Although I see this is as a major product flaw that prevents power query from becoming an scalable solution, the response I've got from Microsoft product team is that no solution was in sight for this issue, and nothing was on their pipeline now or in any foreseable future to approach this. Given that, my suggestion is that you aknowledge the limitations of this tool, remove your data transformation steps from powerquery, migrate them to other reliable tools such as alteryx, Pandas, pentaho, or others.
Actually, there is an approach that can help. I resolved it for us by limiting the queries to ShapePoint. I made a base query, and then referenced all the other queries to it. This way, SharePoint is being pinged once rather than multiple times. Hope this helps you.
Any resolution to this?
We are now experiencing this exact issue.
Ok, I have exactly the same issue, what should we do then? There is no solution for this?
Replying to my own post just to thank all those who responded.
The response from @nickyvv is correct. We opened an issue with Microsoft and they have confirmed this.
I will mark that as the solution for now.
Thanks also to those who responded confirming they were seeing similar issues as that also helped.
Cheers
I am seeing exactly the same issue.
Unfortunately, I don't have a solution for you. However, I think it is beneficial that you know my team has been experiencing the same errors in our premium space on a couple reports that rely heavily on sharepoint data sources.
Hopefully Microsoft support is able to get a fix in place!
Best wishes,
Jacob
I just checked the support page and there seems to be an issue with Premium workspaces that have SharePoint Online as a datasource.
Please check back on that page for a solution or workaround, and maybe you could still also file a support ticket. It might help solve the issue faster.
User | Count |
---|---|
46 | |
26 | |
21 | |
19 | |
17 |
User | Count |
---|---|
51 | |
46 | |
24 | |
20 | |
19 |