Scheduled refresh - Select for which data source

[CPL_HK]

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 

[v-lionel-msft]

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 · Accepted solution]

Hi there

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

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.

[CPL_HK]

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.