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.
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.