Forum Discussion
Connecting to Excel Files: SharePoint Folder vs Local Connection (C:) with On-Premise Gateway
Anonymous I would use Sharepoint even if it is slow if files are not changing frequently and refresh can happen in the background. It eliminates the management of Data Gateway and removes that one layer from the equation. Maybe during development, you can use an on-prem excel file (faster to do that way) and once development is done, switch to Sharepoint, you can easily achieve this by adding parameters to check if you are in development mode or in the production mode.
Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
I don't mind having the Gateway, as it is on the dedicated VM and it's already set up, but do you think it may slow down the process at all?
I think you may be right with your suggestion that on-premise excel files are faster for development while SharePoint is faster for post-development.... but we have been in development for many months and this client continues to want more and more features, so it seems we may never be done with development haha.