{"id":34876,"date":"2023-05-29T17:43:35","date_gmt":"2023-05-29T12:13:35","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=34876"},"modified":"2023-05-29T17:59:36","modified_gmt":"2023-05-29T12:29:36","slug":"add-power-bi-reports-on-model-driven-app-form-with-power-bi-report-control","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2023\/05\/add-power-bi-reports-on-model-driven-app-form-with-power-bi-report-control\/","title":{"rendered":"Add Power BI Reports On Model-Driven App Form with Power BI Report Control"},"content":{"rendered":"

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.<\/p>\n

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.<\/p>\n

To do so, follow the below steps:<\/strong><\/h2>\n

1. Publish your report from the Power BI desktop app.<\/p>\n

\"\"<\/p>\n

2. Select the environment, which you selected in the beginning while publishing the report.
\n\"Power-BI-report-control\"<\/p>\n

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

\"Power-BI-report-control\"<\/p>\n

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.<\/p>\n

\"Power-BI-report-control\"<\/p>\n

\"Power-BI-report-control\"<\/p>\n

After, adding the report, navigate to https:\/\/make.powerapps.com\/<\/a> 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.<\/p>\n

\"Want<\/a><\/p>\n

5. After selecting the entity, click on Add Existing \u00e0 Analytics \u00e0 Power BI Report as shown below.<\/p>\n

\"Power<\/p>\n

6. Add your Power BI report to the solution as presented in the screenshot below.<\/p>\n

\"Power<\/p>\n

7. After selecting the report, navigate to Account\u2019s main form and add a tab.<\/p>\n

\"Power<\/p>\n

8. Then select Power BI Report by clicking on the Component button.<\/p>\n

\"Power<\/p>\n

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.<\/p>\n

\"Power-BI-report-control\"<\/p>\n

Conclusion<\/strong><\/h2>\n

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.<\/p>\n","protected":false},"excerpt":{"rendered":"

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\u2026 Read More: Add Power BI Reports On Model-Driven App Form with Power\u2026 »<\/a><\/span><\/p>\n","protected":false},"author":11,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[38],"tags":[1339,2704],"class_list":["post-34876","post","type-post","status-publish","format-standard","hentry","category-microsoft-powerapps","tag-power-bi","tag-power-bi-report-control"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t