Note: This article is part of a tutorial series on using PowerApps, Microsoft Flow, and Power BI with SharePoint Online. Make sure you read the series introduction to get a sense of the big picture, as well as related downloads.
In this task, we'll publish our dataset and report to the Power BI service; then we'll create a dashboard based on the report. In many cases a report has a large number of visualizations and only a subset are used in a dashboard. In our case, we'll add all four visualizations to the dashboard.
In Power BI Desktop, on the Home tab, click or tap Publish.
If you're not already signed in to the Power BI service, enter an account, then click or tap Sign in.
Enter a password, then click or tap Sign in.
Choose a destination for the report, then click or tap Select. We recommend publishing to a group workspace to simplify access to the report in SharePoint. In this case, we are publishing to the Project Management group workspace. For more information, see Creating groups in Power BI.
After publishing completes, click or tap Open 'project-analysis.pbx' in Power BI.
The Power BI service loads the report in a browser. Click or tap the menu at the top left (a) to see the left navigation pane.
You can see that when we published, Power BI Desktop uploaded a dataset (d) and a report (c). You create dashboards in the service, not Power BI Desktop, and this workspace doesn't have any dashboards yet (b). We'll create one next.
Note: Power BI has a new navigation experience coming out, and it could be enabled in your site. If the left navigation pane looks different from the above image, see The new Power BI navigation experience for more information.
In the service, click or tap in the top right corner, then click or tap Settings.
Click or tap Datasets, then project-analysis.
Expand Data source credentials, then click or tap Edit credentials.
Select OAuth2 for Authentication method, then click or tap Sign in.
Select or sign in to an account that has permissions for the SharePoint lists.
When the process completes, you'll get the following message in the service.
In the service, click or tap the chart on the upper left, then click or tap .
Enter a name for the dashboard you want to pin to, then click or tap Pin.
Click or tap the chart on the upper left, then click or tap tap .
Select the existing dashboard, then click or tap Pin.
Repeat the pinning process for the other two visuals.
In the left navigation pane, click or tap the dashboard name.
Review the dashboard. If you click on a tile, you will go back to the report.
That wraps up most of the work in Power BI. If that was your first experience creating reports and dashboards, congratulations! If you're already a pro, we hope you could move through it quickly. Now we will add alerting to make sure we know if the dashboard needs our attention.
The next step in this tutorial series is to set up data alerts for the Power BI project report.