Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Find articles, guides, information and community news

Most Recent
SamInogic
Super User
Super User

Using the bookmarks feature users can experience the personalized saved report which they can review later quickly in just one click without wasting any time and effort.

Read more...

SamInogic
Super User
Super User

Earlier, Power BI reports on the CRM were directly added to the dashboard. However, recently we received a request from a client, who wanted to view a Power BI report of leads and opportunities related to accounts. He wanted to have this view in a tab on the account form itself.

We researched this request and were able to find a solution! We found out that Microsoft has added a new feature, through which users can now add Power BI report to a model-driven app form.

To do so, follow the below steps:

1. Publish your report from the Power BI desktop app.

1Power-BI-report-control-1.png

 

2. Select the environment, which you selected in the beginning while publishing the report.

2Power-BI-report-control.png

3. Once you publish the report, navigate to https://app.powerbi.com/ and sign in with your CRM credentials. Then, click on Workspaces and select your environment.

3Power-BI-report-control.png

 

4. Click Upload to upload a Power BI report on the Workspace and select the file from File Explorer. Doing so will add the report to your environment.

4Power-BI-report-control.png

5Power-BI-report-control.png

After, adding the report, navigate to https://make.powerapps.com/ Then create a new solution, and add an account or entity to it. Note that you may add any entity, depending on where you would like to show the Power BI report.

 

5. After selecting the entity, click on Add Existing -> Analytics -> Power BI Report as shown below.

6Power-BI-report-control-1.png
6. Add your Power BI report to the solution as presented in the screenshot below.
7Power-BI-report-control.png

7. After selecting the report, navigate to Account’s main form and add a tab.

8Power-BI-report-control-1.png

 

8. Then select Power BI Report by clicking on the Component button.

9Power-BI-report-control-1 (1).png

9. After adding the report save and publish the form. This will enable you to view the Power BI report on the Account form as in the screenshot.

Untitled design.png

Conclusion

By using the new feature, you can unlock the power to aggregate data across systems and tailor it down to the context of a single record.

 

Original Post - https://www.inogic.com/blog/2023/05/add-power-bi-reports-on-model-driven-app-form-with-power-bi-repo... 

Helpful resources

Join Blog
Interested in blogging for the community? Let us know.