Azure Active Directory Logs in Power BI

[johubb]

Hi Team!

I'm trying to build out a Power BI report that connects to our organization's Azure Active Directory where we can see logs of changes. From this old blog post, it looks like this functionality used to be possible https://powerbi.microsoft.com/en-us/blog/azure-active-directory-meets-power-bi/ but has now been depricated. There doesn't seem to be an obvious replacement, unless it means connecting to the O365 API through an Azure AD Application.

Has anyone else had this problem and how did you get around it?

Thanks,

Joe

[v-eachen-msft]

Hi @johubb ,

You could refer to this resolved case:

https://community.powerbi.com/t5/Desktop/Getting-data-from-AAD-as-a-data-source/m-p/86201

Or you could post your idea here to improve Power BI and make this feature coming sooner.

[johubb · Accepted solution]

Hi,

I actually managed to resolve this, albeit not a direct route.

First you need to export Azure Active Directory logs to your log analysics workspace as directed here https://docs.microsoft.com/en-gb/azure/active-directory/reports-monitoring/howto-integrate-activity-...

Then using a blank M query, you ingest your log analytics data as directed here https://docs.microsoft.com/en-us/azure/azure-monitor/platform/powerbi

Whilst it was not the direct route I was hoping for, it does solve the problem and I hope it helps others out there.

Thanks!
Joe

[RobThrive]

I've been hoping for a good solution for this for the last year now. Microsoft were supposed to be putting everything into Microsoft Graph but it is so **bleep** difficult to understand and get anything useful out of Microsoft Graph. All I want is an automated way for AAD sign-in data to be put into PowerBI (NOT service, we use PBIRS).

For example, during this COVID19 lockdown, we have been showing to our board the success of our remote login to do just about everything. We are also showing the good security where we can see thousands of attempted login's from all over the world (on a nice map) and seeing none of them are successful (all our logins should be uK based only, it's amazing to see how many attempted hacks we receive every single day as a small non-profit org trying to do good in the world)

But every single month I need to login, click, click, click and click some more until I can download a CSV, put it into the correct folder and update the report so it pulls in all the CSV data. If I miss that download by one day, I instantly lose a days worth of data!