{"id":101021,"date":"2024-01-23T22:25:16","date_gmt":"2024-01-23T22:25:16","guid":{"rendered":"https:\/\/www.red-gate.com\/simple-talk\/?p=101021"},"modified":"2024-09-03T20:15:16","modified_gmt":"2024-09-03T20:15:16","slug":"power-bi-and-resource-graph-why-you-should-care","status":"publish","type":"post","link":"https:\/\/www.red-gate.com\/simple-talk\/blogs\/power-bi-and-resource-graph-why-you-should-care\/","title":{"rendered":"Power BI and Resource Graph: Why you should care"},"content":{"rendered":"<p>Recently <strong>Azure Resource Graph<\/strong> was <a href=\"https:\/\/blog.fabric.microsoft.com\/en-us\/blog\/microsoft-fabric-november-2023-update\/#post-5122-_Toc1551793704\" target=\"_self\" rel=\"noopener\">announced<\/a> as a new connector in <strong>Power BI<\/strong>.<\/p>\n<p>Azure Resource Graph provides access to almost all resources inside the azure environment of a company.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"681\" height=\"215\" class=\"wp-image-101022\" src=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2023\/12\/a-screenshot-of-a-computer-description-automatica-28.png\" alt=\"A screenshot of a computer\n\nDescription automatically generated\" \/><\/p>\n<h2>Why is this important?<\/h2>\n<p>Resource Graph by itself is a very important tool to analyze the provisioned resources on Azure environment without lose the control of them. It&#8217;s very easy to start provisioning resources and end up lost in a complete mess.<\/p>\n<p>Using the Power BI connector, Power BI becomes a great friend for Azure Solution Architects to make an inventory of everything deployed on the environment.<\/p>\n<p>The connection uses a KQL query, one more reason for you to learn KQL.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"702\" height=\"559\" class=\"wp-image-101023\" src=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2023\/12\/a-screenshot-of-a-computer-description-automatica-29.png\" alt=\"A screenshot of a computer\n\nDescription automatically generated\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>Using the query above, we can build a visual showing the distribution of App Services by region, for example:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"998\" height=\"713\" class=\"wp-image-101024\" src=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2023\/12\/a-screenshot-of-a-graph-description-automatically.png\" alt=\"A screenshot of a graph\n\nDescription automatically generated\" \/><\/p>\n<p>Virtual Machines, Disks, App Services, and many more details, your imagination, Azure and KQL knowledge is your limit<\/p>\n<p>Some time ago I wrote the blog <a href=\"https:\/\/www.red-gate.com\/simple-talk\/blogs\/list-azure-functions-based-on-configuration-values\/\">List Azure Functions based on Configuration Values<\/a> exemplifying how we could use Resource Graph with Powershell to get information from Azure.<\/p>\n<p>It\u2019s a great evolution to be able to use Power BI for the same purpose.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Recently Azure Resource Graph was announced as a new connector in Power BI. Azure Resource Graph provides access to almost all resources inside the azure environment of a company. Why is this important? Resource Graph by itself is a very important tool to analyze the provisioned resources on Azure environment without lose the control of&#8230;&hellip;<\/p>\n","protected":false},"author":50808,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[2,159164,159166],"tags":[5364,145946,158997,101611,159064],"coauthors":[6810],"class_list":["post-101021","post","type-post","status-publish","format-standard","hentry","category-blogs","category-microsoft-fabric","category-powerbi","tag-azure","tag-azure-resource-graph","tag-microsoft-fabric","tag-power-bi","tag-summit-survey"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/101021","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/users\/50808"}],"replies":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/comments?post=101021"}],"version-history":[{"count":1,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/101021\/revisions"}],"predecessor-version":[{"id":101025,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/101021\/revisions\/101025"}],"wp:attachment":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media?parent=101021"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/categories?post=101021"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/tags?post=101021"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/coauthors?post=101021"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}