Power BI can connect to many data sources including Excel. In the previous parts of this 4 part series, we setup the automation to populate an Excel master data file in SharePoint. Next part is to connect the Power BI service to the master Excel file.
The Power BI Service is the online portion of Power BI and for this example there is no need to download the Power BI desktop application.
Step 1: Log into the Power BI web Service from your M365 account and click on Get Data:
![Power BI Service Get Data](https://www.tw-waytek.com/wp-content/uploads/2022/09/BP4-Step1-Power-BI-Service-Get-Data.png)
Step 2: Under Create New Content, select Get Files (no need to download the Power BI Desktop):
![Power BI Service Get Data Files](https://www.tw-waytek.com/wp-content/uploads/2022/09/BP4-Step2-Power-BI-Service-Get-Data-Files.png)
Step 3: Under Create New Content, select Files, and then select SharePoint – Team Sites:
![Select SharePoint Team Sites](https://www.tw-waytek.com/wp-content/uploads/2022/09/BP4-Step3-Select-SharePoint-Team-Sites.png)
Step 4: From you browser, go to the home page of the SharePoint site with the Excel file you want to connect to, copy the full address, and paste it in the box, then click “Connect”:
![Enter the SharePoint Site URL](https://www.tw-waytek.com/wp-content/uploads/2022/09/BP4-Step4-Enter-Site-URL.png)
Step 5: Next select the Shared Documents folder from your SharePoint site, it will take you to your folder list, select the folder and then the file you want to connect to and then click “Connect”:
![Select Shared Documents](https://www.tw-waytek.com/wp-content/uploads/2022/09/BP4-Step5-Select-Shared-Documents.png)
Step 6: In this example, select to “Import” the Excel data into Power BI:
![Import Excel Data](https://www.tw-waytek.com/wp-content/uploads/2022/09/BP4-Step6-Import-Excel-Data.png)
Step 7: The file should now be connected to the Power BI Service:
![Excel Dataset added to Power BI](https://www.tw-waytek.com/wp-content/uploads/2022/09/BP4-Step7-Dataset-is-added-to-Power-BI.png)
Step 8: Select “New” and “Report” for this example:
![Create a New Power BI Report](https://www.tw-waytek.com/wp-content/uploads/2022/09/BP4-Step8-Create-a-New-Power-BI-Report.png)
Step 9: Select “Pick a published dataset”:
![Pick a Published Dataset](https://www.tw-waytek.com/wp-content/uploads/2022/09/BP4-Step9-Pick-a-Published-Dataset.png)
Step 10: Select the Excel file that was just added:
![Select a Dataset to Create Power BI Report](https://www.tw-waytek.com/wp-content/uploads/2022/09/BP4-Step10-Select-a-Dataset-to-Create-Power-BI-Report.png)
Step 11: Click on the button that says “Auto-create report” and select “Create a blank report”:
![Create a Blank Power BI Report](https://www.tw-waytek.com/wp-content/uploads/2022/09/BP4-Step11-Create-a-Blank-Power-BI-Report.png)
Step 12: Build out a report from the dataset:
![Power BI Report Connected to Excel File](https://www.tw-waytek.com/wp-content/uploads/2022/09/BP4-Step12-Power-BI-Report.png)
Below is the data from the Excel file for comparison:
![Excel Data Set](https://www.tw-waytek.com/wp-content/uploads/2022/09/BP5-Step2-Excel-Data-Set-1.png)
Click on the links below to go to each blog post in the series:
Series Summary: Using Power Automate to Move, Rename, and Copy Excel Content to Another Excel File-Click Here!
Series 1 of 4: Copy Email Attachment to SharePoint and Rename-Click Here!
Series 2 of 4: Copy Excel Content (Dynamic) from Excel file to Another-Click Here!
Series 4 of 4: Manage Power BI Data Refresh-Click Here!