Forum Discussion
Data Source not refreshing automatically
Hi,
I am getting this error:
All my files are either EXCELs or CSVs. Data is refreshing in my desktop file without any errors but server gives this error. I have checked all the files sits in sharepoint, noone of the changes are made to accesses wrt any data source.
Because of this issue files are not refreshing automatically.
Can anyone pls help?
Pasting the non-pic version:
Something went wrong
This dataset includes a dynamic data source. Since dynamic data sources aren't refreshed in the Power BI service, this dataset won't be refreshed. Learn more: https://aka.ms/dynamic-data-sources.
- Cluster URIWABI-US-NORTH-CENTRAL-H-PRIMARY-redirect.analysis.windows.net
- Activity IDe1bbf59e-5fcd-130d-7c53-04357893ebfb
- Request IDd356cfb4-0f67-8ae2-7ac7-487159b954fa
- Time2025-06-11 10:40:00ZCopy
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.
4 Replies
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!
