Power Platform Solution and Power BI – Part 2

Intro – Add a Dashboard

In Part 1 we added a Power BI dataset and report to a Power Platform Solution. In Part 2 we will create a dashboard and add it to the model driven app.

Series

• Part 1 – Add Power BI dataset and report to solution
• Part 2 – Show report in a dashboard
• Part 3 – Embed report in a form and add context filtering

YouTube Version

Create the Dashboard

In the solution click on +New and select Dashboard and then Power BI embedded. When the pane on the right hand side loads, enter in a name for your dashboard. Then make sure Power BI report is selected and select your report from the drop down.

Add the Dashboard to the App in the Power Platform Solution

After the dashboard has been added, you can add the dashboard to a model driven app. Edit the app by clicking on the name of it in the Power Platform Solution. Then click on Add Page and the New page dialog appears. On the first page select Dashboard and then click Next. Then on the next page, select your report, probably at the bottom of the list. Finally click Add to add the dashboard to your app.

Note

At the time of publishing there is a small bug that the report doesn’t show correctly in edit mode but if you publish all customisations it fixes it in play mode. Remember this feature

Testing the Report

As with any addition to a development you should test the report works. In my example the report is a direct query. So my test is check the dashboard, then add a new expense record and then return to the dashboard to check the new record is showing.

Conclusion

For some projects this is enough, an embedded dashboard in the model driven app. The next post will be to add an embedded report into a form.

As in Part 1 here are the resources I’ve used

About Power BI in Power Apps Solutions – Power BI | Microsoft Learn