{"id":19087,"date":"2019-06-14T11:42:08","date_gmt":"2019-06-14T11:42:08","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=19087"},"modified":"2022-06-13T14:20:45","modified_gmt":"2022-06-13T08:50:45","slug":"generate-power-bi-report-based-on-logged-in-user-in-dynamic-365-crm-online-restricted-to-his-own-record","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2019\/06\/generate-power-bi-report-based-on-logged-in-user-in-dynamic-365-crm-online-restricted-to-his-own-record\/","title":{"rendered":"How to generate Power BI report based on logged-in user in Dynamics 365 CRM Online (restricted to his own record)"},"content":{"rendered":"<blockquote><p><strong>Note<\/strong> \u2013 Data in report will not follow security roles of logged-in user.<\/p><\/blockquote>\n<h2><strong>Introduction<\/strong><\/h2>\n<p>In this blog we will see how to generate Power BI report based on logged-in user in Dynamics 365 CRM Online.<\/p>\n<h3><strong>Step 1<\/strong><\/h3>\n<p>Create a report in Power BI desktop.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-19088\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/1Power-BI.png\" alt=\"Power BI\" width=\"1265\" height=\"487\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/1Power-BI.png 1265w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/1Power-BI-300x115.png 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/1Power-BI-768x296.png 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/1Power-BI-1024x394.png 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/1Power-BI-660x254.png 660w\" sizes=\"(max-width: 1265px) 100vw, 1265px\" \/><\/p>\n<h3><strong>Step 2<\/strong><\/h3>\n<p>Create a role in Power BI desktop.<\/p>\n<p>Go to modelling -&gt; manage roles -&gt; Create new role here.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-19089\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/2Power-BI.png\" alt=\"Power BI\" width=\"1222\" height=\"608\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/2Power-BI.png 1222w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/2Power-BI-300x149.png 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/2Power-BI-768x382.png 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/2Power-BI-1024x509.png 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/2Power-BI-660x328.png 660w\" sizes=\"(max-width: 1222px) 100vw, 1222px\" \/><\/p>\n<p><strong>Notes:<\/strong><\/p>\n<p>While creating DAX expression-<\/p>\n<ul>\n<li>Create condition like above<\/li>\n<li>[domainname]-This contains email id of user<\/li>\n<li>Userprincipalname ()-returns logged-in user email id<\/li>\n<li>We are comparing with email id because Power BI returns users email id only<\/li>\n<\/ul>\n<h2><strong>Difference between Username () and Userprincipalname ()-<\/strong><\/h2>\n<p>Username () return user in domain\/user format &#8211; (Logged-in user on system).<\/p>\n<p style=\"padding-left: 360px;\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-19090\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/3Power-BI-1.png\" alt=\"Power BI\" width=\"242\" height=\"230\" \/><\/p>\n<p>Userprincipalname () return user in user (email id) format.<\/p>\n<h3><strong>Step 3<\/strong><\/h3>\n<p>After creating a role apply that role.<\/p>\n<p>Go to modelling -&gt; view as role -&gt; select role which you have created.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-19091\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/4Power-BI.png\" alt=\"Power BI\" width=\"1107\" height=\"561\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/4Power-BI.png 1107w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/4Power-BI-300x152.png 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/4Power-BI-768x389.png 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/4Power-BI-1024x519.png 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/4Power-BI-660x334.png 660w\" sizes=\"(max-width: 1107px) 100vw, 1107px\" \/><\/p>\n<h3><strong>Step 4<\/strong><\/h3>\n<p>Create relationship in Power BI desktop between system user\u2019s entity and other entity which you are using while creating report.<\/p>\n<p>Go to Home -&gt; Manage relationships -&gt; new<\/p>\n<p>Create new relationship here.<\/p>\n<p>Select primary keys as shown below.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-19092\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/5Power-BI.png\" alt=\"Power BI\" width=\"1065\" height=\"716\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/5Power-BI.png 1065w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/5Power-BI-300x202.png 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/5Power-BI-768x516.png 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/5Power-BI-1024x688.png 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/5Power-BI-660x444.png 660w\" sizes=\"(max-width: 1065px) 100vw, 1065px\" \/><\/p>\n<h3><strong>Step 5<\/strong><\/h3>\n<p>Now publish report to Dynamics 365 CRM and pin that report on dashboard.<\/p>\n<p>Go to CRM and add that dashboard:<\/p>\n<ul>\n<li>Publish report from here.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-19093\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/6Power-BI.png\" alt=\"Power BI\" width=\"1231\" height=\"649\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/6Power-BI.png 1231w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/6Power-BI-300x158.png 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/6Power-BI-768x405.png 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/6Power-BI-1024x540.png 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/6Power-BI-660x348.png 660w\" sizes=\"(max-width: 1231px) 100vw, 1231px\" \/><\/p>\n<ul>\n<li>Select your workspace.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-19094\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/7Power-BI.png\" alt=\"Power BI\" width=\"1228\" height=\"615\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/7Power-BI.png 1228w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/7Power-BI-300x150.png 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/7Power-BI-768x385.png 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/7Power-BI-1024x513.png 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/7Power-BI-660x331.png 660w\" sizes=\"(max-width: 1228px) 100vw, 1228px\" \/><\/p>\n<ul>\n<li>Click on Pin Live Page to make Power BI report visible on dashboard.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-19095\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/8Power-BI.png\" alt=\"Power BI\" width=\"1122\" height=\"554\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/8Power-BI.png 1122w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/8Power-BI-300x148.png 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/8Power-BI-768x379.png 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/8Power-BI-1024x506.png 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/8Power-BI-660x326.png 660w\" sizes=\"(max-width: 1122px) 100vw, 1122px\" \/><\/p>\n<ul>\n<li>Give a name to your dashboard and make it live.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-19096\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/10Power-BI.png\" alt=\"Power BI\" width=\"1205\" height=\"646\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/10Power-BI.png 1205w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/10Power-BI-300x161.png 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/10Power-BI-768x412.png 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/10Power-BI-1024x549.png 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/10Power-BI-660x354.png 660w\" sizes=\"(max-width: 1205px) 100vw, 1205px\" \/><\/p>\n<ul>\n<li>Go to CRM and add this dashboard<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-19097\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/11Power-BI.png\" alt=\"Power BI\" width=\"1265\" height=\"619\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/11Power-BI.png 1265w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/11Power-BI-300x147.png 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/11Power-BI-768x376.png 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/11Power-BI-1024x501.png 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/11Power-BI-660x323.png 660w\" sizes=\"(max-width: 1265px) 100vw, 1265px\" \/><\/p>\n<p>Here choose your workspace and dashboard.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-19098\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/12Power-BI.png\" alt=\"Power BI\" width=\"1050\" height=\"635\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/12Power-BI.png 1050w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/12Power-BI-300x181.png 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/12Power-BI-768x464.png 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/12Power-BI-1024x619.png 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/12Power-BI-660x399.png 660w\" sizes=\"(max-width: 1050px) 100vw, 1050px\" \/><\/p>\n<h2><strong>Step 6<\/strong><\/h2>\n<p>Now go to Power BI service.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-19099\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/13Power-BI.png\" alt=\"Power BI\" width=\"1393\" height=\"807\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/13Power-BI.png 1393w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/13Power-BI-300x174.png 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/13Power-BI-768x445.png 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/13Power-BI-1024x593.png 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/13Power-BI-660x382.png 660w\" sizes=\"(max-width: 1393px) 100vw, 1393px\" \/><\/p>\n<p>Click on your dataset -&gt; Security.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-19100\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/14Power-BI.png\" alt=\"Power BI\" width=\"1416\" height=\"813\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/14Power-BI.png 1416w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/14Power-BI-300x172.png 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/14Power-BI-768x441.png 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/14Power-BI-1024x588.png 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/14Power-BI-660x379.png 660w\" sizes=\"(max-width: 1416px) 100vw, 1416px\" \/><\/p>\n<p>Add user\u2019s email for whom you want the Power BI dashboard to be visible in CRM.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-19101\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/15Power-BI-1.png\" alt=\"Power BI\" width=\"1383\" height=\"584\" \/><\/p>\n<h3><strong>Step 7<\/strong><\/h3>\n<p>After adding on dashboard share that dashboard to other users.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-19102\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/16Power-BI.png\" alt=\"Power BI\" width=\"1069\" height=\"612\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/16Power-BI.png 1069w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/16Power-BI-300x172.png 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/16Power-BI-768x440.png 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/16Power-BI-1024x586.png 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/16Power-BI-660x378.png 660w\" sizes=\"(max-width: 1069px) 100vw, 1069px\" \/><\/p>\n<h3><strong>Step 8<\/strong><\/h3>\n<p>After sharing the dashboard please log in with the user credentials for which you have shared the report and add that dashboard. You can see report with user logged-in data.<\/p>\n<p>Report of admin (Report Creator):<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-19107\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/17Power-BI-1.png\" alt=\"Power BI\" width=\"1413\" height=\"723\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/17Power-BI-1.png 1413w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/17Power-BI-1-300x154.png 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/17Power-BI-1-768x393.png 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/17Power-BI-1-1024x524.png 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/17Power-BI-1-660x338.png 660w\" sizes=\"(max-width: 1413px) 100vw, 1413px\" \/><\/p>\n<p>Report of user 1:<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-19108\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/18Power-BI-1.png\" alt=\"Power BI\" width=\"1366\" height=\"720\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/18Power-BI-1.png 1366w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/18Power-BI-1-300x158.png 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/18Power-BI-1-768x405.png 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/18Power-BI-1-1024x540.png 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/18Power-BI-1-660x348.png 660w\" sizes=\"(max-width: 1366px) 100vw, 1366px\" \/><\/p>\n<p>Report of user 2:<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-19109\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/19Power-BI-1.png\" alt=\"Power BI\" width=\"1395\" height=\"619\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/19Power-BI-1.png 1395w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/19Power-BI-1-300x133.png 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/19Power-BI-1-768x341.png 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/19Power-BI-1-1024x454.png 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/19Power-BI-1-660x293.png 660w\" sizes=\"(max-width: 1395px) 100vw, 1395px\" \/><\/p>\n<h2><strong>Conclusion<\/strong><\/h2>\n<p>We are able to see Power BI reports in Dynamics 365 CRM Online based on logged in user.<\/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\">Cut short 90% of your manual work and repetitive data entry!<\/div><\/div><\/h2>\n<p style=\"text-align: left;\"><em>Get 1 Click apps and say goodbye to all repetitive data entry in CRM &#8211;<\/em><br \/>\n<em><strong><a href=\"https:\/\/bit.ly\/3oH7dYw\" target=\"_blank\" rel=\"noopener noreferrer\">Click2Clone<\/a> <\/strong>\u2013 Clone\/Copy Dynamics 365 CRM records in 1 Click<\/em><br \/>\n<em><strong><a href=\"https:\/\/bit.ly\/3EPjAYc\" target=\"_blank\" rel=\"noopener noreferrer\">Click2Export<\/a><\/strong> \u2013 Export Dynamics 365 CRM Report\/CRM Views\/Word\/Excel template in 1 Click<\/em><br \/>\n<em><strong><a href=\"https:\/\/bit.ly\/3EN8h2v\" target=\"_blank\" rel=\"noopener noreferrer\">Click2Undo<\/a><\/strong> \u2013 Undo &amp; Restore Dynamics 365 CRM data in 1 Click<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Note \u2013 Data in report will not follow security roles of logged-in user. Introduction In this blog we will see how to generate Power BI report based on logged-in user in Dynamics 365 CRM Online. Step 1 Create a report in Power BI desktop. Step 2 Create a role in Power BI desktop. Go to\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.inogic.com\/blog\/2019\/06\/generate-power-bi-report-based-on-logged-in-user-in-dynamic-365-crm-online-restricted-to-his-own-record\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":23752,"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":[45],"tags":[1883,1339],"class_list":["post-19087","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-power-bi","tag-microsoft-powerbi","tag-power-bi"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/19087","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=19087"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/19087\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media\/23752"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=19087"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=19087"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=19087"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}