Forum Discussion
analitika123
Helper II
4 years agoError while trying to setup schedul refresh in Power BI Service
Hello,
I would like to ask how to fix this error:
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.
- Data source for Query1
6 Replies
- JirkaZ
Solution Specialist
This article (and the linked articles) should give you all the answers you're looking for.
Chris Webb's BI Blog: Video: Power BI Data Privacy Settings Deep Dive Chris Webb's BI Blog (crossjoin.co.uk)In short - Power Query doesn't support dynamic data sources. When you for example are using Web.Contents connector, the provided URL has to be hardcoded. There are ways you can make the URL dynamic and those ways are described in the article.
- analitika123
Helper II
I don't get which part I should change.
- JirkaZ
Solution Specialist
Hard to tell if I don't know the M code for the query