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 ,
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!