Azure Power BI Tagging Reports

Overview

This solution extracts tagging from all the subscriptions of which the user who runs the scripts has access to. It exports the data to an Excel file. Power BI Desktop is used to provide several visualizations. There are four reports, each with four additional variations of each report. The variation being the primary visualization.

*Resources without tags are represented with a NULL value.

Prerequisites

Please ensure that you have PowerShell 5.1 and the modules listed below installed.

*Please ensure that you change the environment variable in the script if you are not using Azure Commercial.

PowerShell

PowerShell version 5.1

Install Azure Az Module

Install ImportExcel Module

Power BI Desktop

Please ensure that you have Power BI Desktop and the visualization listed installed.

Install Power BI Desktop

How to add visualizations from the marketplace?

Add Word Cloud

Add Bubble Chart by Akvelon (using the free version)

Instructions

Ensure the prerequisites have been completed.

1. Open PowerShell as administrator
2. Run the Tagging-Report-V3.ps1
3. Navigate to the path were the file was exported and confirm that it exist and that you see data.
4. Open Azure Tagging Reports.pbix file in PowerBI Desktop. If you kept the path and folders with the default settings, the reports will populated automatically.

Sample Reports

Sample Report 1

Sample Report 2

Sample Report 3

Sample Report 4

A special thanks to Ernest Oshokoya for providing the original PowerShell script!