Error : You can't schedule refresh for this dataset because...

[Cyberfred95]

Hi

I am trying to schedule a Powerbi project. 
When I go to Dataset/Setting I have the error below :

I am using a Personal Gateway. The refresh in manual within desktop works fine.
As sources I have  only  :

• some odbc  sources that query files in local a shared storage (Z:), no credential are necessary.
• 3 Excel files.

I checked the Power BI-supported Data source for refresh and Odbc and Excel (of course) are on the list.
I checked that my sources were not considered as dynamic resources see my source definition page :

So, I do not understand why I have this message. Can you please help me to troubleshoot the problem?

Let me know if you need any other clarifications.

Thanks for your help

Regards.

[v-zhangti]

Hi, @Cyberfred95 

Right now this type of data source is not supported to refresh in the Power BI Service.

What you can do as a workaround is to use the relative path option as shown below:

https://medium.datadriveninvestor.com/setting-a-scheduled-refresh-on-a-dynamic-data-source-in-power-... 

https://blog.crossjoin.co.uk/2016/08/16/using-the-relativepath-and-query-options-with-web-contents-i... 

https://docs.microsoft.com/power-bi/connect-data/refresh-data#refresh-and-dynamic-data-sources

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Cyberfred95]

Hi

Thanks for your help.

When you say: "this type of datasource is not supported" : which type of data source are you referring to ?
I have no dynamic  data source in my project.

Regards.

[Cyberfred95]

Anyone can help me please?

[Cyberfred95]

Anyone can help me please?