Page 188 - MS Office 365 for Dummies 3rd Ed (2019)
P. 188
FIGURE 12-9:
Adding local data to Power BI.
FIGURE 12-10:
An Excel files data imported into Power BI as a dataset.
4. ChoosewhetheryouwanttoconnectPowerBItoyourExcelfileor import the entire Excel file into Power BI.
In our case we just want the data, so we will choose to Import Excel Data into Power BI. Once the process is complete, you will find the spreadsheet data in your Workspace under the Datasets tab as shown in Figure 12-10.
You are now ready to build reports and share them with others.
172 PART4 DivingintoOfficeOnline