Connecting to Excel Files: SharePoint Folder vs Local Connection (C:) with On-Premise Gateway

Hey Anonymous ,

I agree with Matt, the performance to Sharepoint is not good.

How fast do the files change? And how many times per day do you want them to be loaded?

If you just refresh a few times per day, I would store them in Sharepoint and load them with dataflows. Like this you don't really mind if it's slow, because it's loaded anyway in the Power BI Service. And the connection to the loaded table of the data flow is super fast. And you won't need the VM with gateway as everything is in the cloud.

See also the documentation:

Introduction to dataflows and self-service data prep - Power BI | Microsoft Docs