Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Cyberfred95
Frequent Visitor

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

Hi

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

 

Cyberfred95_0-1645107982067.png

 

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 :

Cyberfred95_1-1645108524482.png

 

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.

 

4 REPLIES 4
v-zhangti
Community Support
Community Support

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.

 

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
Frequent Visitor

Anyone can help me please?

Cyberfred95
Frequent Visitor

Anyone can help me please?

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors