Track the status of your Azure environment with Power BI Dashboards

One of my favorite quotes of all time is from William Edwards Deming, where he says that without data, you’re just another person with an opinion. When using Power BI, I remember that quote very well because having the data we can arrange it to find answers for questions that we have not even thought to ask . Power BI is a tool that can manage the data efficiently. We can retrieve and display information from our Azure subscriptions, which gives a cloud purpose for such a profound quote. Although it is not in the resource box of many cloud administrators, we will explore how to install the tool and start checking your Azure governance with some Power BI Dashboards available to Azure customers.

We will explore the Power BI Dashboard Governance, which includes information about management groups and subscriptions, resource groups and resource tagging, Azure security and compliance, Azure Policies, Azure subscription blueprints, and, last but not least, regulatory standards compliance overview.

This article aims to show how to download the Power BI Desktop, download your first dashboard, and start using it to manage your Azure environment. The permission required to execute the steps provided in this article is for a reader at the subscription level.

Installing Power BI Desktop

The first step in our journey is the installation of Power BI Desktop software on your workstation. The software is available in 32 and 64 bits. Visit this Microsoft website and download your version (64 bits is recommended).

The installation process is straightforward. On the first page, we will be selecting the language and then click Next to continue and follow the installation process. The final page of the installation wizard will be a message saying (hopefully) that you have completed installing Microsoft Power BI Desktop. Click on Finish, but before doing that, make sure that you select Launch Microsoft Power BI Desktop.

The image below shows the Power BI Desktop welcome page with information to get started, a blog, and some hints to start using the product. Don’t worry about that at this moment.

Power BI Dashboard

One important note to mention is that a new folder structure will be created under the Documents folder as part of the installation process. A new folder called Power BI Desktop and a subfolder called Custom Connectors will be created. Please pay attention to that path because we will need to use it in the following section.

Installing the Custom Connector

The magic happens with a Custom Connector in the Power BI world. We will be using one called CCODashboardAzureConnector.mez, which can be found on this GitHub location here.

GitHub sometimes is not easy to navigate but hit the download button (highlighted area in the image below).

Power BI Dashboard

This is an important step. Make sure that you save the file you have just downloaded to the following path: C:Users<username>DocumentsPower BI DesktopCustom Connectors folder, where you should replace <username> for the current user. The final result should be something similar to the image below.

Power BI Dashboard

Time to start configuring the Power BI Desktop. After opening the application, click on File, Options and Settings, and then click on the Options item located on the right side.

On the Options page, the first stop is in the Security item under GLOBAL. In the Data Extensions section, select “(Not Recommended) Allow any extension to load without validation or warning.”

The second step is to click on Privacy (Item 1) and then select “Always ignore Privacy Level Settings” (Item 2). Click OK, and you will be prompted to restart Power BI Desktop. Make sure you do it.

Getting the PowerBI template

Now that we have all the plumbing configured, including the Power BI Desktop software, Custom Connector, in the right place, our next logical step is to download the Power BI Dashboard file. This file can be found here.

You can save this file in any location on your computer. Double click on it to open it. The first page will be selecting your Azure environment (I believe that for 95 percent of the readers, the option will be Global. If you are Government, then select that one), and click on Load.

On the Access Web Content page, click on Organizational Account, click on Sign in, and follow the required steps to authenticate to Azure. Note: There is the current status right above the sign-in button, and it will change when you are authenticated.

You will be prompted to enter your credentials again on the “Connect CCO Dashboard to your Azure subscription” screen. Just type your credentials again and click on Connect.

Exploring the Dashboards

At this point, we will have all dashboards available (Item 1), and we can pick and choose the ones that we want to check. In the Azure Resources Security, Compliance and Regulatory Standards, we can have a nice view of all resources, their health status, and so forth. We can always filter the information by subscription, policy set, and regulatory standards.

Power BI Dashboard

The filer and selection criteria are based on the dashboard. For example, in the Azure Policies, we can select the subscriptions, management groups, and policy scope.

Power BI Dashboard

Getting everything together … the lazy way!

We created three lines of code to download the Custom Connector and the Dashboard that we presented in this article. You can copy and paste the content below and save it as ps1 and execute it on your workstations. A folder in the C:Techgenix-AzureGovernance will be created (as long as you have permission), and the files will be placed there.

New-Item -Path "c:" -Name "Techgenix-AzureGovernance" -ItemType "directory"
Invoke-WebRequest -Uri "https://github.com/Azure/ccodashboard/blob/306a7b36e5ee3662eab12e04687c90a5f0ccf49c/dashboards/CCODashboard-Governance/CcoDashboardAzureConnector.mez" -OutFile "C:Techgenix-AzureGovernanceCcoDashboardAzureConnector.mez"
Invoke-WebRequest -Uri "https://github.com/Azure/ccodashboard/raw/master/dashboards/CCODashboard-Governance/CCO%20Power%20BI%20Governance%20Dashboard%20v2.2.pbit" -OutFile "C:Techgenix-AzureGovernanceCCO Power BI Governance Dashboard v2.2.pbit"

Your Power BI Dashboard is up and running

In this article, we covered the required steps to build a control platform of your Azure environment without going to the Azure Portal, just using data gathered by the Power BI Dashboard from your Azure subscriptions to provide rich reporting capabilities about the current status and health of your Azure environment.

Featured image: Shutterstock


Post Views:
17


15 Comments

  1. My brother recommended I might like this blog. He was entirely right. This post actually made my day. You cann’t imagine simply how much time I had spent for this info! Thanks!

  2. What抯 Happening i am new to this, I stumbled upon this I’ve discovered It absolutely useful and it has aided me out loads. I’m hoping to give a contribution & help other customers like its aided me. Great job.

  3. I really like what you guys tend to be up too. Such clever work and
    reporting! Keep up the good works guys I’ve included you guys to our blogroll.

  4. Howdy! I know this is kind oof off topic but I was wondering which blog platform are yyou using for this website?I’m
    getting sick and tired of WordPress because I’ve had problems with
    hackers and I’m looking at alternatives for another platform.

    I would be great if you ould point mme in the direction of a
    good platform.

  5. I believe that is one of the most important info for me. And i am satisfied studying your article. However wanna statement on few common things, The site style is wonderful, the articles is truly excellent : D. Good job, cheers

  6. Thanks for one’s marvelous posting! I quite enjoyed reading it,
    you will be a great author.I will make sure to bookmark your blog and will eventually come back sometime soon. I want
    to encourage you to ultimately continue your great work, have a nice morning!

  7. Do you mind if I quote a few of your posts as long as I provide
    credit and sources back to your blog? My blog site is in the very same niche as yours and my users
    would definitely benefit from a lot of the information you present here.
    Please let me know if this okay with you. Regards!

  8. Whats up this is kind of of off topic but I was wanting to know if blogs
    use WYSIWYG editors or if you have to manually code with
    HTML. I’m starting a blog soon but have no coding skills so I wanted to get advice from someone with
    experience. Any help would be enormously appreciated!

  9. Excellent way of explaining, and good paragraph
    to get information on the topic of my presentation subject
    matter, which i am going to present in school.

  10. If some one wishes to be updated with most recent technologies therefore he must be visit this web site and be up to date daily.

  11. Every weekend i used to pay a visit this website, because i wish for enjoyment, for the reason that this this site conations in fact nice funny material too.

  12. For latest information you have to visit the web and on web I found this web page as a
    most excellent web site for most recent updates.

  13. Hey there would you mind letting me know which webhost you’re using?
    I’ve loaded your blog in 3 different browsers and I must
    say this blog loads a lot faster then most. Can you suggest
    a good hosting provider at a reasonable price? Thank you, I appreciate it!

  14. I am sure this paragraph has touched all the internet visitors, its really really nice paragraph on building up
    new web site.

  15. It’s going to bee end of mine day, bbut before ending I am reading this
    impressive article to improve my know-how.

Leave a Reply

Your email address will not be published.