It is very easy to connect Power BI to a SharePoint Excel file. Here’s a quick tutorial on how to do it:
- On Power BI's main dashboard, head over to the left-side panel and click 'Create'.
- Choose 'Excel' from the list of options.
- After that, enter the file path of your SharePoint Excel file into the provided input field.
- Subsequently, configure the Connection Credentials based on your preferences.
- Finally, tap 'Next' to enable the connection and use the selected SharePoint Excel file as the data source for your Power BI's report output.
