Forum Discussion
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...
Are you able to store the information in a dataflow instead, as that can handle the brunt of the refresh burden that you mentioned doesn't matter
After which you can query that to the dashboard - should be significantly faster!