The visualization should now look like the following image. As you can see, projects that Irvin Sayers runs tend to start a lot later after approval. There could be factors other than the assigned manager, but this would be worth looking into. That brings us to the end of the report section, and you should now have a complete report based on data imported from SharePoint and cleaned up and modeled in Power BI Desktop. If everything went according to plan, your report should look like the following image. You are now to publish this report to the Power BI service. Task 6: Publish the Power BI report and create a dashboard In this task, we’ll publish our data set 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. Publish the data set and report: 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 . 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.
The visualization should now look like the following image. As you can see, projects that Irvin Sayers runs tend to start a lot later after approval. There could be factors other than the assigned manager, but this would be worth looking into. That brings us to the end of the report section, and you should now have a complete report based on data imported from SharePoint and cleaned up and modeled in Power BI Desktop. If everything went according to plan, your report should look like the following image. You are now to publish this report to the Power BI service. Task 6: Publish the Power BI report and create a dashboard In this task, we’ll publish our data set 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. Publish the data set and report: 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 . 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.