{"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":"<p>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<p>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<h2><strong>To do so, follow the below steps:<\/strong><\/h2>\n<p>1. Publish your report from the Power BI desktop app.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-34899\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/05\/1Power-BI-report-control-1.jpeg\" alt=\"\" width=\"1324\" height=\"788\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/05\/1Power-BI-report-control-1.jpeg 1324w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/05\/1Power-BI-report-control-1-300x179.jpeg 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/05\/1Power-BI-report-control-1-1024x609.jpeg 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/05\/1Power-BI-report-control-1-768x457.jpeg 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/05\/1Power-BI-report-control-1-660x393.jpeg 660w\" sizes=\"(max-width: 1324px) 100vw, 1324px\" \/><\/p>\n<p>2. Select the environment, which you selected in the beginning while publishing the report.<br \/>\n<img decoding=\"async\" class=\"alignnone size-full wp-image-34880\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/05\/2Power-BI-report-control.jpeg\" alt=\"Power-BI-report-control\" width=\"594\" height=\"372\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/05\/2Power-BI-report-control.jpeg 594w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/05\/2Power-BI-report-control-300x188.jpeg 300w\" sizes=\"(max-width: 594px) 100vw, 594px\" \/><\/p>\n<p>3. Once you publish the report, navigate to <a href=\"https:\/\/app.powerbi.com\/\" target=\"_blank\" rel=\"noopener\">https:\/\/app.powerbi.com\/<\/a> and sign in with your CRM credentials. Then, click on Workspaces and select your environment.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-34879\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/05\/3Power-BI-report-control.jpeg\" alt=\"Power-BI-report-control\" width=\"406\" height=\"729\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/05\/3Power-BI-report-control.jpeg 406w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/05\/3Power-BI-report-control-167x300.jpeg 167w\" sizes=\"(max-width: 406px) 100vw, 406px\" \/><\/p>\n<p>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<p><img decoding=\"async\" class=\"alignnone size-full wp-image-34878\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/05\/4Power-BI-report-control.jpeg\" alt=\"Power-BI-report-control\" width=\"1332\" height=\"502\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/05\/4Power-BI-report-control.jpeg 1332w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/05\/4Power-BI-report-control-300x113.jpeg 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/05\/4Power-BI-report-control-1024x386.jpeg 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/05\/4Power-BI-report-control-768x289.jpeg 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/05\/4Power-BI-report-control-660x249.jpeg 660w\" sizes=\"(max-width: 1332px) 100vw, 1332px\" \/><\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-34877\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/05\/5Power-BI-report-control.jpeg\" alt=\"Power-BI-report-control\" width=\"863\" height=\"538\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/05\/5Power-BI-report-control.jpeg 863w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/05\/5Power-BI-report-control-300x187.jpeg 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/05\/5Power-BI-report-control-768x479.jpeg 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/05\/5Power-BI-report-control-660x411.jpeg 660w\" sizes=\"(max-width: 863px) 100vw, 863px\" \/><\/p>\n<p>After, adding the report, navigate to <a href=\"https:\/\/make.powerapps.com\/\" target=\"_blank\" rel=\"noopener\">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<p><a href=\"https:\/\/www.inogic.com\/services\/microsoft-power-platform\/microsoft-power-apps-model-driven-apps\/\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" class=\"alignnone size-full wp-image-34897\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/05\/Want-to-visualize-and-build-up-a-Model-Driven-App.gif\" alt=\"Want to visualize and build up a Model Driven App\" width=\"700\" height=\"200\" \/><\/a><\/p>\n<p>5. After selecting the entity, click on Add Existing \u00e0 Analytics \u00e0 Power BI Report as shown below.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-34893\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/05\/6Power-BI-report-control-1.jpeg\" alt=\"Power BI report control\" width=\"879\" height=\"561\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/05\/6Power-BI-report-control-1.jpeg 879w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/05\/6Power-BI-report-control-1-300x191.jpeg 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/05\/6Power-BI-report-control-1-768x490.jpeg 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/05\/6Power-BI-report-control-1-660x421.jpeg 660w\" sizes=\"(max-width: 879px) 100vw, 879px\" \/><\/p>\n<p>6. Add your Power BI report to the solution as presented in the screenshot below.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-34884\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/05\/7Power-BI-report-control.jpeg\" alt=\"Power BI report control\" width=\"432\" height=\"323\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/05\/7Power-BI-report-control.jpeg 432w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/05\/7Power-BI-report-control-300x224.jpeg 300w\" sizes=\"(max-width: 432px) 100vw, 432px\" \/><\/p>\n<p>7. After selecting the report, navigate to Account\u2019s main form and add a tab.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-34892\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/05\/7Power-BI-report-control-1.jpeg\" alt=\"Power BI report control\" width=\"1088\" height=\"419\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/05\/7Power-BI-report-control-1.jpeg 1088w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/05\/7Power-BI-report-control-1-300x116.jpeg 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/05\/7Power-BI-report-control-1-1024x394.jpeg 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/05\/7Power-BI-report-control-1-768x296.jpeg 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/05\/7Power-BI-report-control-1-660x254.jpeg 660w\" sizes=\"(max-width: 1088px) 100vw, 1088px\" \/><\/p>\n<p>8. Then select Power BI Report by clicking on the Component button.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-34891\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/05\/8Power-BI-report-control-1.jpeg\" alt=\"Power BI report control\" width=\"1109\" height=\"775\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/05\/8Power-BI-report-control-1.jpeg 1109w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/05\/8Power-BI-report-control-1-300x210.jpeg 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/05\/8Power-BI-report-control-1-1024x716.jpeg 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/05\/8Power-BI-report-control-1-768x537.jpeg 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/05\/8Power-BI-report-control-1-660x461.jpeg 660w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/05\/8Power-BI-report-control-1-200x140.jpeg 200w\" sizes=\"(max-width: 1109px) 100vw, 1109px\" \/><\/p>\n<p>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<p><img decoding=\"async\" class=\"alignnone size-full wp-image-34890\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/05\/10Power-BI-report-control-1-1.jpeg\" alt=\"Power-BI-report-control\" width=\"1173\" height=\"638\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/05\/10Power-BI-report-control-1-1.jpeg 1173w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/05\/10Power-BI-report-control-1-1-300x163.jpeg 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/05\/10Power-BI-report-control-1-1-1024x557.jpeg 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/05\/10Power-BI-report-control-1-1-768x418.jpeg 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/05\/10Power-BI-report-control-1-1-660x359.jpeg 660w\" sizes=\"(max-width: 1173px) 100vw, 1173px\" \/><\/p>\n<h2><strong>Conclusion<\/strong><\/h2>\n<p>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":"<p>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 <span class=\"read-more\"><a href=\"https:\/\/www.inogic.com\/blog\/2023\/05\/add-power-bi-reports-on-model-driven-app-form-with-power-bi-report-control\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":11,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"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":[],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/34876","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/comments?post=34876"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/34876\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=34876"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=34876"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=34876"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}