{"id":13357,"date":"2018-11-13T18:19:35","date_gmt":"2018-11-13T12:49:35","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=13357"},"modified":"2022-07-19T16:26:44","modified_gmt":"2022-07-19T10:56:44","slug":"different-ways-of-publishing-power-bi-reports-in-dynamics-365-crm","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2018\/11\/different-ways-of-publishing-power-bi-reports-in-dynamics-365-crm\/","title":{"rendered":"Different ways of Publishing Power BI reports in Dynamics 365 CRM"},"content":{"rendered":"<p style=\"text-align: justify;\"><strong>Introduction:<\/strong><\/p>\n<p style=\"text-align: justify;\">In our <a href=\"https:\/\/www.inogic.com\/blog\/2016\/09\/steps-to-integrate-dynamics-crm-online-and-power-bi\/\" target=\"_blank\" rel=\"noopener noreferrer\">previous blog<\/a> we have seen how to create Power BI reports using Dynamics 365 connector. In order to publish Power BI report, you must have a Power BI service account associated with it.<\/p>\n<p style=\"text-align: justify;\">In this blog, we will see how we can add Power BI report in Dynamics CRM dashboards.<\/p>\n<p style=\"text-align: justify;\">Once you published your Power BI report to Power BI service now it\u2019s time to publish Power BI report into CRM.<\/p>\n<p style=\"text-align: justify;\">There are 3 different ways using which we can add Power BI reports in CRM.<\/p>\n<h2 style=\"text-align: justify;\">1. Adding Power BI Dashboard to Personal Dashboard in CRM.<\/h2>\n<p style=\"text-align: justify;\">You can add Power BI report to personal dashboard using Power BI tile in CRM.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-13358\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/11\/1Different-ways-of-Publishing-Power-BI-reports-in-Dynamics-365-CRM.png\" alt=\"Different ways of Publishing Power BI reports in Dynamics 365 CRM\" width=\"820\" height=\"371\" \/><\/p>\n<p>Select the Power BI Dashboard and Select the individual Power BI report from Power BI dashboard.<\/p>\n<p style=\"padding-left: 120px;\"><img decoding=\"async\" class=\"aligncenter wp-image-13359 \" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/11\/2Different-ways-of-Publishing-Power-BI-reports-in-Dynamics-365-CRM.png\" alt=\"Different ways of Publishing Power BI reports in Dynamics 365 CRM\" width=\"355\" height=\"522\" \/><\/p>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-13360 \" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/11\/3Different-ways-of-Publishing-Power-BI-reports-in-Dynamics-365-CRM.png\" alt=\"Different ways of Publishing Power BI reports in Dynamics 365 CRM\" width=\"813\" height=\"577\" \/><\/p>\n<p>If you are not able to see Power BI tile option then we need to allow Power BI visualizations for reporting section in System settings.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-13361 \" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/11\/4Different-ways-of-Publishing-Power-BI-reports-in-Dynamics-365-CRM.png\" alt=\"Different ways of Publishing Power BI reports in Dynamics 365 CRM\" width=\"822\" height=\"520\" \/><\/p>\n<h2>2. Adding Power BI report to System Dashboard in CRM.<\/h2>\n<p style=\"text-align: justify;\">Adding Power BI report in personal dashboard is limited only for the user who has created dashboard. You need to share personal dashboard to the user who need to access Power BI reports.<\/p>\n<p style=\"text-align: justify;\">So if we add Power BI report in system dashboard then we don\u2019t need to share Power BI reports to other users as all the users on the system can access the Power BI report.<\/p>\n<p style=\"text-align: justify;\">Following are the steps to add Power BI report to system dashboard.<\/p>\n<ul>\n<li style=\"text-align: justify;\">Go to the Settings-&gt;Customizations-&gt;Customize the system-&gt;Dashboards.<\/li>\n<li style=\"text-align: justify;\">Create new system dashboard.<\/li>\n<li style=\"text-align: justify;\">Select the IFRAME Source.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-13362 \" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/11\/5Different-ways-of-Publishing-Power-BI-reports-in-Dynamics-365-CRM.png\" alt=\"Different ways of Publishing Power BI reports in Dynamics 365 CRM\" width=\"824\" height=\"486\" \/><\/p>\n<ul>\n<li>Get the embed code from the Power BI report.<\/li>\n<\/ul>\n<p>Navigate to the File-&gt;Publish to web for the report to get embed code for that report.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-13363 \" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/11\/6Different-ways-of-Publishing-Power-BI-reports-in-Dynamics-365-CRM.png\" alt=\"Different ways of Publishing Power BI reports in Dynamics 365 CRM\" width=\"823\" height=\"425\" \/><\/p>\n<p style=\"padding-left: 90px;\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-13364\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/11\/7Different-ways-of-Publishing-Power-BI-reports-in-Dynamics-365-CRM.png\" alt=\"Different ways of Publishing Power BI reports in Dynamics 365 CRM\" width=\"535\" height=\"360\" \/><\/p>\n<ul>\n<li>Copy and paste the embed code in the IFrame URL and uncheck the restrict cross-frame scripting.<\/li>\n<\/ul>\n<p style=\"padding-left: 90px;\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-13365\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/11\/8Different-ways-of-Publishing-Power-BI-reports-in-Dynamics-365-CRM.png\" alt=\"Different ways of Publishing Power BI reports in Dynamics 365 CRM\" width=\"473\" height=\"663\" \/><\/p>\n<ul>\n<li>Save and publish the dashboard you can see you Power BI report in system dashboard.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-13366 \" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/11\/9Different-ways-of-Publishing-Power-BI-reports-in-Dynamics-365-CRM.png\" alt=\"Different ways of Publishing Power BI reports in Dynamics 365 CRM\" width=\"818\" height=\"411\" \/><\/p>\n<h2><strong>3. Adding power BI report in Power BI dashboard<\/strong><\/h2>\n<p style=\"text-align: justify;\">You can also add Power BI dashboard directly into CRM. When you allow Power BI visualizations embedding in system settings then you will be able to see option for adding Power BI dashboard in CRM.<\/p>\n<p style=\"padding-left: 210px;\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-13368\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/11\/10Different-ways-of-Publishing-Power-BI-reports-in-Dynamics-365-CRM.png\" alt=\"Different ways of Publishing Power BI reports in Dynamics 365 CRM\" width=\"203\" height=\"86\" \/><\/p>\n<p style=\"text-align: justify;\">In order to add Power BI dashboard in CRM you first need to create Power BI dashboard in Power BI service.<\/p>\n<p style=\"text-align: justify;\">You can add multiple Power BI report tiles in single Power BI Dashboard. For adding Power BI tile in Power BI dashboard you need IFrame source of Power BI report.<\/p>\n<p style=\"padding-left: 30px;\"><img decoding=\"async\" class=\"aligncenter wp-image-13369 size-full\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/11\/11Different-ways-of-Publishing-Power-BI-reports-in-Dynamics-365-CRM.png\" alt=\"Different ways of Publishing Power BI reports in Dynamics 365 CRM\" width=\"535\" height=\"362\" \/>Copy and Paste the IFrame Source into Web Content of Power BI Tile.<\/p>\n<p style=\"padding-left: 150px;\"><img decoding=\"async\" class=\"aligncenter wp-image-13370 \" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/11\/12Different-ways-of-Publishing-Power-BI-reports-in-Dynamics-365-CRM.png\" alt=\"Different ways of Publishing Power BI reports in Dynamics 365 CRM\" width=\"376\" height=\"572\" \/><\/p>\n<blockquote><p>Note: When you have RLS enabled for the Power BI report then you will not be able to get embed code and IFrame source so all the above ways will work only if you have embed code for the Power BI report.<\/p><\/blockquote>\n<p style=\"text-align: justify;\">So if you don\u2019t have embed code for the Power BI report you can still publish Power BI report using \u201c<strong>Pin Live Page<\/strong>\u201d option in Power BI Service.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-13371 \" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/11\/13Different-ways-of-Publishing-Power-BI-reports-in-Dynamics-365-CRM.png\" alt=\"Different ways of Publishing Power BI reports in Dynamics 365 CRM\" width=\"829\" height=\"45\" \/><\/p>\n<p>Select the Power BI Dashboard or create new Power BI dashboard.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-13372\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/11\/14Different-ways-of-Publishing-Power-BI-reports-in-Dynamics-365-CRM.png\" alt=\"Different ways of Publishing Power BI reports in Dynamics 365 CRM\" width=\"646\" height=\"375\" \/><\/p>\n<p>So here is your Power BI Dashboard will appear in CRM.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-13373 \" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/11\/15Different-ways-of-Publishing-Power-BI-reports-in-Dynamics-365-CRM.png\" alt=\"Different ways of Publishing Power BI reports in Dynamics 365 CRM\" width=\"828\" height=\"348\" \/><\/p>\n<p style=\"text-align: justify;\">So using all of the above ways you can add Power BI reports to CRM Dashboards.<\/p>\n<p style=\"text-align: justify;\">You also need to give Power BI report access to the users otherwise you will receive \u201cThis content isn\u2019t available\u201d message.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-13374 \" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/11\/16Different-ways-of-Publishing-Power-BI-reports-in-Dynamics-365-CRM.png\" alt=\"Different ways of Publishing Power BI reports in Dynamics 365 CRM\" width=\"823\" height=\"331\" \/><\/p>\n<p style=\"text-align: justify;\">You need to give individual users Power BI report access permission by either sharing report with other users or giving user\u2019s Power BI Data access.<\/p>\n<blockquote><p><strong>Note: <\/strong>You must have a Power BI Pro account in order to share Power BI report or allow Power BI data access to other users.<\/p><\/blockquote>\n<h2 style=\"text-align: justify;\">Conclusion:<\/h2>\n<p style=\"text-align: justify;\">Using the simple steps above user can add Power BI report in Dynamics CRM dashboards.<\/p>\n<h2 style=\"text-align: left;\"><div class=\"su-heading su-heading-style-default su-heading-align-center\" id=\"\" style=\"font-size:15px;margin-bottom:5px\"><div class=\"su-heading-inner\">70% of global 2000 companies apply gamification to improve productivity and returns!<\/div><\/div><\/h2>\n<p><em><strong><a href=\"https:\/\/bit.ly\/3RD4lYW\" target=\"_blank\" rel=\"noopener noreferrer\">Gamifics365<\/a> <\/strong>\u2013 Spin the magic of games within Microsoft Dynamics 365 CRM to improve user adoption, enhance productivity, and achieve company goals!<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction: In our previous blog we have seen how to create Power BI reports using Dynamics 365 connector. In order to publish Power BI report, you must have a Power BI service account associated with it. In this blog, we will see how we can add Power BI report in Dynamics CRM dashboards. Once you\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.inogic.com\/blog\/2018\/11\/different-ways-of-publishing-power-bi-reports-in-dynamics-365-crm\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":13383,"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":[16,18,19,45],"tags":[1339,1340,1342],"class_list":["post-13357","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dynamics-365","category-dynamics-365-v9-2","category-dynamics-crm","category-power-bi","tag-power-bi","tag-power-bi-dynamics-365","tag-power-bi-dynamics-crm"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/13357","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\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/comments?post=13357"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/13357\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media\/13383"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=13357"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=13357"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=13357"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}