Error while trying to setup schedul refresh in Power BI Service

[analitika123]

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

[JirkaZ]

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

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]

I don't get which part I should change.

[JirkaZ]

Hard to tell if I don't know the M code for the query

[analitika123]

So I need change M code where connections to data are in transform data?  I have M code for select from table, selecting columns etc. 

[JirkaZ]

This is a complex topic. If you really want to understand what's going on in your case, I recommend you read those articles I linked. And yes - it's about the M code for the data connection.

[analitika123]

Connection to excel: