Forum Discussion
"Power BI Web Refresh Error: Issues with SharePoint Online Data Source After Publishing"
Community Championdo 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.