- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

You must connect using the followings :
And when it asks the URL, copy paste only the root URL.
Hope it helps.
Regards
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
07-08-2024 05:07 AM | |||
10-14-2024 12:32 AM | |||
12-27-2024 04:02 AM | |||
05-20-2024 03:45 AM | |||
08-19-2024 08:22 PM |
User | Count |
---|---|
141 | |
115 | |
84 | |
63 | |
48 |