Power Platform Solution and Power BI – Part 1
Power BI reports can be an important part of a Power Platform solution. Microsoft has added a new feature to Power Platform Solutions to add a Power BI dataset and report. Then you can add the Power BI report in as a dashboard or as an embedded report in a form and add context filtering. Part 1 will cover adding the Power BI dataset and report to the solution.
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
Preparation
For this post I have a Power Platform solution already. I have a Power BI report connected to the environment and published to a workspace.
Add Power BI to Power Platform Solution
First task is to add the Power BI report to the solution. Start by clicking on Add Existing and from Analytics selecting Power BI report. This will bring the underlying dataset in as well. Then click on From Power BI which will show you a workspace drop down*.
From the drop down, we select the right workspace and then the right report. Then we click on Add.
It takes a while for the dataset and report to be added. Behind the scenes a new workspace is created and the report is copied to there. If you don’t have permission to create a workspace you will get errors.
Checking the New Workspace
I recommend that you check the workspace. Check the credentials in the dataset and refresh the dataset and finally make sure the report opens and shows data. Remember to setup a refresh schedule if your report needs it.
Note the message across the top telling you that this is a workspace connected to a solution and the workspace icon is the Power Apps icon.
Finishing the connection part
The report is connected to this environment’s Dataverse. When the solution is exported and imported the report needs to be connected to the new environment’s Dataverse.
In the solution, I clicked on the three dots and selected Edit. Then a pane will appear on the right. Then select Yes from for the existing connection question and click Save.
Conclusion and Resources
Congratulations, you now have a solution that includes a Power BI report.
This is just Part 1. The future parts will cover adding a dashboard and an embedded report. Here are the resources I have used.
About Power BI in Power Apps Solutions – Power BI | Microsoft Learn
More Power BI Posts
- Conditional Formatting Update
- Data Refresh Date
- Using Inactive Relationships in a Measure
- DAX CrossFilter Function
- COALESCE Function to Remove Blanks
- Personalize Visuals
- Gradient Legends
- Endorse a Dataset as Promoted or Certified
- Q&A Synonyms Update
- Import Text Using Examples
- Paginated Report Resources
- Refreshing Datasets Automatically with Power BI Dataflows
- Charticulator
- Dataverse Connector – July 2022 Update
- Dataverse Choice Columns
- Switch Dataverse Tenancy
- Connecting to Google Analytics
- Take Over a Dataset
- Export Data from Power BI Visuals
- Embed a Paginated Report
- Using SQL on Dataverse for Power BI
- Power Platform Solution and Power BI Series
- Creating a Custom Smart Narrative
- Power Automate Button in a Power BI Report