Forum Discussion
Refresh with a column containing a custom function
Hi Darryl_Rosin,
The issue occurs because your query builds the SharePoint URL dynamically from a column, creating a dynamic data source that Power BI Service cannot refresh. Microsoft documentation states that such data sources are not supported for refresh in most cases. Try using a static base URL and avoid passing full URLs dynamically; instead, use Web.Contents with RelativePath so only the path changes while the data source remains fixed. This allows the dataset to refresh successfully in the Service.
Web.Contents - PowerQuery M | Microsoft Learn
Data refresh in Power BI - Power BI | Microsoft Learn
Thank you.
Thank-you, but Source in your script returns a table with 20 rows. The list on /sites/Hub is not included so HubList returns an error.
Hi Darryl_Rosin,
The issue occurs because your query builds the SharePoint URL dynamically from a column, creating a dynamic data source that Power BI Service cannot refresh. Microsoft documentation states that such data sources are not supported for refresh in most cases. Try using a static base URL and avoid passing full URLs dynamically; instead, use Web.Contents with RelativePath so only the path changes while the data source remains fixed. This allows the dataset to refresh successfully in the Service.
Web.Contents - PowerQuery M | Microsoft Learn
Data refresh in Power BI - Power BI | Microsoft Learn
Thank you.