Forum Discussion
"Power BI Web Refresh Error: Issues with SharePoint Online Data Source After Publishing"
Hello everyone,
I'm facing an issue with a Power BI report that pulls data from a SharePoint Online folder. The report works flawlessly on Power BI Desktop version, but once published, I'm unable to refresh the data on the web version. The following error appears when I attempt to refresh:
Based on the error and the information like "Content", "Name", "Extension", it seems that the issue is related to listing the files on the SharePoint site. I'm almost certain that I'm using the same account in the Power BI Online version to refresh the dataset as in the Power BI Desktop version, so I'm puzzled as to why the refresh is failing on the web.
Do you have any suggestions on how to solve this problem or what might be causing this refresh error? Any help would be greatly appreciated.
Thank you in advance for your support!
3 Replies
- vanessafvg
Community Champion
do you have a lot of content in your sharepoint site? the sharepoint.files() function is the default when using the sharepoint folder, this loads all the metadata of the sharepoint site and if it has a lot of content, the load might get slower, you might want to consider changing that function to sharepoint.content() as its more performant. it could be that its timing out because its too slow?
Thank you for your response.
I appreciate the suggestion, however, I use the same `SharePoint.Files()` function for other reports connected to the same SharePoint site, and those refresh without any issues. The performance and loading times for these reports are within acceptable limits, which leads me to believe that the problem with my current report might not be due to the amount of content or a timeout issue.
Do you have any other ideas on what might be causing the refresh to fail only on this specific report after publication, but not in the Power BI Desktop version?
Hi Tchapeto
Thanks for the solution vanessafvg provided,based on your description, please check that if you have some error in power query, if you make some change in power query, check your steps to make sure that each step is right.
And please check that iif you have make the credential for the data source in data source settings in Service after publishing the report. You can refer to the following link.
https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-data#accessing-cloud-data-sources
Solved: Expression Error : There weren't enough elements i... - Microsoft Fabric Community
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
