Forum Discussion
Solved
Refresh with a column containing a custom function
Hello. My semantic model reads from a sharepoint list. Each row has a column that contains a unique url to another sharepoint site. I have a function that takes the site url from this column and ...
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.
Hi Darryl_Rosin,
Checking in to see if your issue has been resolved. let us know if you still need any assistance.
Thank you.