Forum Discussion
PowerBi Audit Log
- Hi there
This is what I currently use and it works really well.
http://angryanalyticsblog.azurewebsites.net/index.php/2018/02/16/power-bi-audit-log-analytics-solution/
I would like to access the Audit Log details related to Power BI services such as dataset details, count of datasets, number of users, active user details etc, using Power Shell scripts. While i explored i found the possible way to achieve this functionality is through Exchange Online. But i dont have privileges to execute Exchange Online cmdlets. Can you please help me, is there any alternate way to achieve this one.
By default, Audit Logs require Tenant Admin privileges.
But there is a work around we use.
In the Exchange Admin Center, you can create an admin role called "View-Only Audit Logs" or something similar.
For the Roles, assign the "View-Only" Audit Logs role.
Then add the role to the user who should get access. By doing this, a non-Tenant Admin can access the Audit Logs.
Of course there are various security concerns to keep in mind, but it is a techinical solution to get around the limitation of needing Tenant Admin permissions to see the Audit Logs.
- The data is in the dataset. You just need to add in some additional logic
Thank you for your quick reply. Would you possibly be able to point me to a reference document that lets me know what is available inside the dataset? Or if you know, is there some powershell command I can use to iterate through all of it so that I can then go back and select the items I am interested in?