Did anyone say Azure Active Directory reports in PowerBi?

Introduction

A few days ago an announcement was made that there a PowerBI content pack has been published for Azure Active Directory! So let’s take that one out for a spin today and see what it can bring to the table.

 

Setting up the integration

This is one of the reasons I really like “cloud”! Integration almost has no entry barrier! Anyhow, in PowerBi, click on “Get Data”.

2017-01-24-10_06_33-power-bi

 

Go the “Services”-tile in the “Content Pack Library”

2017-01-24-10_06_44-power-bi

And select “Azure Active Directory Activity Logs”

2017-01-24-10_06_58-power-bi

Enter your tenant name

2017-01-24-10_07_12-power-bi

Authenticate with a Global Admin

2017-01-24-10_07_26-power-bi

And … it’s gathering the data from AAD

2017-01-24-10_08_43-azure-active-directory-activity-logs-power-bi

… wait for it …

2017-01-24-10_09_59-azure-active-directory-activity-logs-power-bi

Done!

 

Default Reports

Now let’s see what we get out of the box… We start with the following dashboard ;

2017-01-24-10_10_26

Nice nice… And the reports? One report has been provided out-of-the-box, which has three tabs in it ;

2017-01-24-10_26_19

What can we get from that?

2017-01-24-10_11_37-azure-active-directory-activity-logs-power-bi

2017-01-24-10_17_43-program-manager

That already provides a lot of information imho!

 

Customize it?

Now what if you don’t see what you are looking for?

600



You can still create your own reports! You get the following data sets …

2017-01-24-10_18_41-program-manager

Looking to for the actual fields?

2017-01-24-10_29_03-program-manager 2017-01-24-10_29_24-program-manager 2017-01-24-10_29_36-program-manager 2017-01-24-10_29_45-azure-active-directory-activity-logs-power-bi 2017-01-24-10_29_54-azure-active-directory-activity-logs-power-bi 2017-01-24-10_30_03-azure-active-directory-activity-logs-power-bi

 

Closing Thoughts

The Azure Active Directory pack gives you an easy way to get insights into the usage of your tenant. Imho, a must have for any AAD owner! 😉

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s