Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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

Does anybody have any recommendations for the best way to import Excel Files to Power BI Desktop?   Currently, my PBIX file is connected to about 25 Excel files that are locally stored on the C: dr...
Need Help
Tips and Tricks
v-lionel-msft's avatar
v-lionel-msft
Community Support
5 years ago

Hi Anonymous ,

 

Or you can consider Matt’s suggestion to store the data source files on the server where the gateway is located? 

But don't put the gateway and data source files in the VM, this does not help much to improve performance.

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    I actually already have the data source files on the server where the gateway is located, which is on the VM. I have dedicated the VM for this project, but the PBIX file is still quite slow.