Forum Discussion
Multiple Files with on-premise data gateway schedule refresh
It sounds like you should probably move the data from Excel into something like SQL Server.
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
It sounds like you should probably move the data from Excel into something like SQL Server.
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
Yes thank you. SQL server setup would be ideal for a future step. OneDrive location would be good short term.
Thanks for the suggestions.
