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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
CPL_HK
Frequent Visitor

Scheduled refresh - Select for which data source

Dear Team,

 

I have been running a scheduled refresh in PowerBI Service of a SQL database via gateway and it worked perfectly fine. I then added an additional data source (an Excel file) in PowerBI Desktop and after publishing the file, I received a scheduled refresh error:  the credentials for the (locally saved) Excel file are wrong. However, I don't even want to refresh the Excel file in PowerBI service (it's some data which doesn't change), I just want to refresh the SQL part. There is no way to activate scheduled refresh tough, as all credentials of all data sources need to be correct. 

 

How can I either only do a scheduled refresh for one of the two data sources, or alternatively configure the Excel file in a way that PowerBI does not think of it as a source it has to refresh in PowerBI service?

 

The problem is also described in the video here (at around 4:30). 

https://www.youtube.com/watch?v=uxsQUArF2Ts

 

Thank you,

Christian 

 

 

1 ACCEPTED SOLUTION
GilbertQ
Super User
Super User

Hi there


Go into Power Query and remove the "Include in report refresh"

 

image.png

 

If that does not work, copy the contents of your Excel file.

Go into the Query Editor.

Then click on "Enter Data"

Press CTRL + V and click Ok

 

Now you have got your data, which does not have any data sources associated to it.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

3 REPLIES 3
v-lionel-msft
Community Support
Community Support

Hi @CPL_HK ,

If your excel file is located locally, you must configure the gateway for it.

In other words, you must configure the gateway for the local data source.

So you can upload your excel file to the cloud, such as OneDrive / SharePoint.

use-onedrive-business-links 

 

Best regards,
Lionel Chen

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

GilbertQ
Super User
Super User

Hi there


Go into Power Query and remove the "Include in report refresh"

 

image.png

 

If that does not work, copy the contents of your Excel file.

Go into the Query Editor.

Then click on "Enter Data"

Press CTRL + V and click Ok

 

Now you have got your data, which does not have any data sources associated to it.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Thank you - I hardcopied it. Doesn't really make sense for me that I PowerBI service doesn't deactivate the refresh although this is done in PowerBI desktop, not sure if this is a bug. 

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!