Power BI Excel file
Excel can be used as data source for Power BI report. When the Excel file is on SharePoint or OneDrive, using SharePoint data source might have performance issue when it tries to navigate through the SharePoint folder/files. We can use Web data source to connect to the Excel file directly to eliminate the overhead with folder/file navigation.
If you used the copy path option to get a direct link to the file from OneDrive/SharePoint you can use the URL as is.
Posted by John Liu Thursday, July 20, 2023