- 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

Multiple Files with on-premise data gateway schedule refresh
Hi!
We have SharePoint 2013 (local server, not microsoft cloud) hosting many excel files (up to 150). In app.powerbi, I have a few dataset source files connected with scheduled refresh using the on-premise data gateway bridge that provides authentication and connects to sharepoint.
What is best practice for creating data sources for multiple files? It seems I may need to create 150 data sources, each pointing to its respective file url on the sharepoint server. Is there an easier way to map files?
Many thanks,
Tim
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

It sounds like you should probably move the data from Excel into something like SQL Server.
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

As an alternative to SQL Server (which would probably be sensible). You could move the files to OneDrive for Business (attached to a Power BI Workgroup), you wouldn't need the Gateway then and can enumerate all the files on one go.
These files could be synced from on premise using ODFB automatically.
HTH
Sacha
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

It sounds like you should probably move the data from Excel into something like SQL Server.
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

As an alternative to SQL Server (which would probably be sensible). You could move the files to OneDrive for Business (attached to a Power BI Workgroup), you wouldn't need the Gateway then and can enumerate all the files on one go.
These files could be synced from on premise using ODFB automatically.
HTH
Sacha
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Yes thank you. SQL server setup would be ideal for a future step. OneDrive location would be good short term.
Thanks for the suggestions.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
04-19-2024 09:36 AM | |||
08-17-2023 11:35 AM | |||
Anonymous
| 05-13-2020 07:26 AM | ||
05-27-2024 08:20 AM | |||
Anonymous
| 03-03-2021 09:00 AM |
User | Count |
---|---|
33 | |
18 | |
14 | |
11 | |
10 |