Forum Discussion
Data Source not refreshing automatically
Even though your Excel/CSV files are stored in SharePoint and refresh correctly in Power BI Desktop, the error you're seeing in the Power BI Service indicates that your data source is being treated as dynamic—this typically happens when the file path is constructed using parameters, custom functions, or M code like Web.Contents() or SharePoint.Files() with dynamic elements. Power BI Service does not support such dynamic sources for scheduled refresh due to security restrictions. To resolve this, ensure your data source uses a static SharePoint path—for example, connect using the SharePoint Folder connector (SharePoint.Files("https://yourdomain.sharepoint.com/sites/yoursite", [ApiVersion = 15])) and apply filters through the Power Query UI rather than modifying the M code or using parameters. Re-publish the report after making these changes.
Hi pragagar ,
Just checking in to see if the earlier response helped clarify the issue regarding the dynamic data source error on Power BI Service.
As noted, this usually occurs when certain transformations or file access patterns (like Web.Contents with dynamic URLs or parameterized SharePoint paths) are used, which Power BI Service cannot refresh due to security restrictions.
If you’ve had a chance to review and try the suggestions shared by BhavinVyas3003 earlier , If you're still facing issues or need help adjusting the queries for a supported setup, feel free to drop in a sample or let us know more.
Looking forward to hearing from you!
Hi pragagar ,
I understand that you're experiencing issues with refreshing your dataset in the Power BI service, despite it working correctly on your desktop. The error message indicates that your dataset includes a dynamic data source, which is not supported for automatic refresh in the Power BI service.
If the guidance provided by BhavinVyas3003 earlier has resolved your issue, please mark their response as the Accepted Answer. This will assist others in the community who may have similar questions.
If you continue to face challenges or need further clarification, please share more details, and we’ll be more than happy to assist you!
Thank you for being an active member of the Microsoft Fabric Community!
Hi pragagar
We understand you're encountering issues refreshing your dataset in the Power BI service, even though it refreshes successfully in Power BI Desktop. The error you're seeing typically occurs when the dataset includes a dynamic data source, which is currently not supported for scheduled or automatic refresh in the Power BI service.If the solution shared earlier by BhavinVyas3003 helped resolve your issue, we kindly encourage you to mark it as the Accepted Answer. This helps other community members who might be facing similar challenges.
If you're still experiencing difficulties or need additional support, please feel free to share more details we're here to help!
Thank you for being a valuable part of the Microsoft Fabric Community!