Page 187 - MS Office 365 for Dummies 3rd Ed (2019)

FIGURE 12-8:
Adding apps for services to pull data into Power BI.
you can connect to everything from Google Analytics to GitHub to MailChimp and ZenDesk. And of course you can connect to other Office 365 apps as well!
To pull data into Power BI to analyze, click the Get button under Services from the initial landing page. You will then be presented with options for the services from which you can pull data, as shown in Figure 12-8.
In this case, let’s pull in some data from a local Excel file. Power BI uses a concept called Workspaces to keep things organized. By default, you have a workspace that is just for you. You can create organizational workspaces, but you will need some- thing beyond the free plan to do so.
To pull Excel data into Power BI:
1. OpenyourbrowserandnavigatetothePowerBIwebsite.
You can find Power BI on the apps menu in Office 365 (refer back to Figure 12-7)
or you can navigate to it directly at https://app.powerbi.com.
2. Onthewelcomescreen,clicktheGetbuttonintheFilesboxunderthe
Create New Content section as shown in Figure 12-9.
You can also get to this welcome screen by clicking on the Workspaces tab on the left and selecting your personal workspace.
3. ChoosethelocationoftheExcelfileyouwanttoimport.
If it is on your local computer, choose Local File. If it is in your OneDrive or SharePoint site, select those options. In this example we will use the Financial Sample data Microsoft provides. You can find this file at https://docs. microsoft.com/en-us/power-bi/sample-financial-download.
CHAPTER12 GettingintoDatawithExcelOnlineandPowerBI 171