Forum Discussion
Azure Active Directory Logs in Power BI
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
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-logs-with-log-analytics
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
3 Replies
- v-eachen-msft
Community Support
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.
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-logs-with-log-analytics
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
Resolver I
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!
