Reply
Andre-SiS
Frequent Visitor
Partially syndicated - Outbound

Automatic refresh with one of the sources as a local file

In my report, I have two data sources: sales information from Business Central, and a local excel-file that lists all postal codes in my country.  The latter is used for filtering and contains about 18 000 rows. 

 

In app.powerbi.com I want to set up the report for automatic updates. 

Now, before I added the local file, it worked like a charm. 

 

However, once I added the local file, I get this error: 

 

Data source error:

Scheduled refresh is disabled because at least one data source is missing credentials. To start the refresh again, go to this dataset's settings page and enter credentials for all data sources. Then reactivate scheduled refresh.

 

Now obviously, this is correct since app.powerbi doesn't have access to my local file. 

However, the local file doesn't need updating since it's just static values. 

 

How can I use a local file and a BC source, and turn on automatic updates but only for the BC source? 

1 ACCEPTED SOLUTION
dadb25
Helper I
Helper I

Syndicated - Outbound
Hi Andre-Sis, You need a Gateway to connect your local file to Power BI : https://powerbi.microsoft.com/en-us/gateway/ Otherelse, you can store your local file in a Sharepoint, or Onedrive. In that case you don't need a Gateway to refresh your Dataset. Regards

View solution in original post

4 REPLIES 4
dadb25
Helper I
Helper I

Syndicated - Outbound
Hi Andre-Sis, You need a Gateway to connect your local file to Power BI : https://powerbi.microsoft.com/en-us/gateway/ Otherelse, you can store your local file in a Sharepoint, or Onedrive. In that case you don't need a Gateway to refresh your Dataset. Regards

Syndicated - Outbound

Thank you!  I moved the local file to a sharepoint - but how do I connect it to my report? I tried using the link option (URL) in PowerBI, but it didn't work. 

Syndicated - Outbound

You must connect using the followings :

 

dadb25_1-1702641863901.png

dadb25_2-1702641905719.png

 

And when it asks the URL, copy paste only the root URL.

Hope it helps.

Regards

Syndicated - Outbound

Thank you, I also looked at this for help: 
https://youtu.be/DWG0uvgg5nM?si=y2GWSVhPukQ0lbbf

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)