Reply
RemoteUser1
Regular Visitor
Partially syndicated - Outbound

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

2 ACCEPTED SOLUTIONS
Greg_Deckler
Super User
Super User

Syndicated - Outbound

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...

View solution in original post

Syndicated - Outbound

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

 

View solution in original post

3 REPLIES 3
Greg_Deckler
Super User
Super User

Syndicated - Outbound

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...

Syndicated - Outbound

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

 

Syndicated - Outbound

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

 

Thanks for the suggestions.

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)