Build Your Own Power BI Audit Log; Usage Metrics Across the Entire Tenant

[@williamrhopkins]

For those of you who have Sentinel there is a connector for the PBI Audit Data which can be used to ingest the audit logs. The data is then easily exported for analysis purposes. The advantage is automated ingestion and the data retention that Sentinel offers plus easy export to a csv file. I am not sure that Sentinel extracts all of the Audit Data (for example the SectionName of the report doesn't seem to be present ) But thanks for pointing out the usefulness of the PBI audit data for usage reporting

[@jimmychua1573]

Do you have a blog or video instruction on how to automate powershell for this process?

[@chandrasekhar1883]

Hi team, i have one requirement. I have report in premium workspace and granted direct access to 1000 users to this report . Now business asking they want to see that 1000 users email id in one report and later if i will add 2 more user to direct access then count should automatically show 1002 . Now i am maintain one excel sheet manually to show the count. Can is it possible to automate.

[@AndyKabeer]

Hi, great video, is it possible to track what filter conditions were used while running a report (especially time filter ) by a user using an audit log?

[@kthakk7]

Great video, but I'm finding it difficult to get audit log info at the report PAGE level. I'm looking for the number of views on a specific report page. Any ideas?

[@lindabond9307]

PS @RADACAD Love seeing your work for Dept of Premier and Cabinet in my home town and state in Australia ;)

[@tjvillanueva396]

Hi, can you show us a tutorial about the automation? The video is really helpful!

[@RADACAD]

a video will come on that subject

[@pavelrehak5481]

Nice video Reza! Yep, I would also like to see the automation part using the Azure.

[@chamilam]

Is there a video available on how to automate?

[@CharlieRice1977]

@@RADACAD Thanks for this tutorial. Very helpful. What is the name of the video for automating getting the data?

[@shraddhabatwalkar5411]

@@RADACAD Have you uploaded the video for the automation if yes can you please share the link here

[@user-xh1cx]

Thanks Reza. I want to load the only audit data column ,is that possible to load only one column to the drive ?

[@swapnillabhe]

I am getting below error Search-UnifiedAuditLog : The term 'Search-UnifiedAuditLog' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.

[@samuelmanseau467]

Excellent video ! Clear & ready to use ! thanks a lot !

[@jacodiafransman676]

Does the audit data have acitivities logged for report Pages

[@user-od3rl5mc]

Could you do a video using the more up to date method using PowerShell cmdlets of Power BI itself?

[@shivamchaudhary4456]

Hi, I wanted to know if we can also get the information on which tab of the report is getting maximum views out of the whole report. Do you think that is an option or the data that gets extracted doesn't include that.

[@venkatnadha]

Can we filter Workspace name in the PowerShell Script ? If Yes What is the code in PowerShell?

[@shahidsangresikoppa8762]

this is a wonderful content. Good job.. thanks for sharing

[@rakeshkumarsharma195]

Hi RADCAD, Can you help me out how can i get ReportPage level transaction in Audit Log, Thanks.

[@rajuchoudhari2409]

Thanks. do you have any video on power bi capacity management, in particularly about how to approach - resolving premium capacity is at 100 percent - emails I get all the time ? if you could create video walkthrough of resolving this using premium capacity metrics app and/or tenant reporting app that would be very helpful.

[@adnanazad6102]

Reviewing data modeling of reports causing the spikes could be worth, the causes can be identified by checking “Evidence” page. A common mistake by noob developers is using many to many relationships between fact tables, look for those on top of checking with built in power for acne analyser of Power BI.

[@galatemalate1256]

Can I know the name of all existent reports and workspaces with this? Also can I know all users that can create workspaces and which they can not?

[@venkatnadha]

How to Pass mutiple Value for -ActivityType in Power Shell Script?

[@murtazaulhasan]

How can we automate this process and other API calls for PowerBI using Azure Data Task Factory/SSIS, especially if MFA is enabled?

[@shivetaraina8889]

can you share the script if we have more than 5000 results?

[@douglasparisio]

This solution works in on premise environment ?

[@sabertala8116]

Thanks Reza, was quite useful tutorial, can we use audit log feature on local power BI server? (Not on cloud)

[@jochenjuelke265]

PBI Report Server has other interfaces to get usage data, as a starting point you can create a TSQL Query on SQL ReportServerDB , check View ExecutionLog3

[@mohank9811]

hi, can this be done for power bi embedded?. We have a power bi report that is embedded on our web site and the users log in to our web site and view the report without having power bi accounts.

[@chamilam]

Thanks a lot Reza this helps a lot.

[@jochenjuelke265]

@RADACAD Can you tell what are the least minimal permissions needed of the AAD User to access the O365 Audit Logs, Filtered only for the "Power BI" entries? Only beeing in the "Power BI Service Administrator" Group (having access to PBI Management Portal) is not enough. Do i really need to be an O365 Global Admin (which i never will get permissions for in my company)? Thanks for insights, Jochen

[@RADACAD]

There is a new method to achieve this log too. using PowerShell cmdlets of Power BI itself, which can be easier and I believe would work with PBI Service admin role too. I'll do a blog/video on that.

[@RJ2BIg]

@@RADACAD hi do you have a link to this for me? Can't find it

[@KB-wb9ym]

@@RADACAD Hi Reza, can you please share this blog/video if you have done it already? Thanks

[@singamsivagangireddy8175]

Hi, Excellent Video.

[@bhagwangaikwad6642]

I have the global admin access but still the issue occured.

[@gdmitrich]

Love it!

[@lindabond9307]

If anyone is wondering why Power BI - Admin Portal just shows "Capacity settings" only > this is view for non-admins (just to make it confusing :) )

Hi I'm not allowed to install the Exchange Management Tools. So I can't use the Search-UnifiedAuditLog command. I'm looking for another alternative, anythoughts about it?

[@RADACAD]

there is another way to use management API too. I'll explain it later in another video.

@@RADACAD Thanks! I owe you one or two drinks (or one million) for your blog posts!

[@leocamposjf]

Only in Premium Licence, correct?

[@RADACAD]

no. even in pro. you would need to have admin rights though

[@AdrianHernandez-wv1dg]

Is there anyway that something similar can be done but on Power BI Reporting Server? Our company uses on prem server and we would like to know our reports usage statistics.

[@jochenjuelke265]

PBI Report Server has other interfaces to get usage data, as a starting point you can create a TSQL Query on SQL ReportServerDB , check View ExecutionLog3

[@TinyKideo]

Hello! Dude, I have been searching for this with no success. Any update from your side?