Forum Discussion
Microsoft EmployeeUsage Metrics for Dashboard/Report Authors Feedback
We have developed an automated method of pulling the O365 Power BI audit logs. When I evaluate the logs for ViewReport or ViewDashboard for a specific report or dashboard, the numbers don't align with the usage metrics. I am consistently seeing higher unique user and view counts in the usage metrics compared to the audit logs. Can you explain the discrepancy? Which are more accurate?
I've noticed this issue as well on my end. The usage metrics do not appear to tie to the Audit Log details. Please advise why this would be the case.
vaibhav_oscAdvocate I
zthill Was wondering if the method of pulling O365 audit logs gives access to who/when accessed the reports as well..
I was trying to use the inbuilt usage metrics but the details doesn't seem to be enough as well as the performance is quite poor and on certain occasions the visual doesn't even load. Hence, I'm looking at alternative ways to implement this.
Yes it does. You have to use PowerShell to automate pulling the logs
More info can be found here https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-auditing/
Hey there! I'm currently looking into how to pull the logs automatically, but I'm just at the beginning. Can you share how you automatically pull the data from Power BI? That would be really helpful!
Many thanks ahead, Chris
FYI - we followed the information provided here:
https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-auditing/
We have a PowerShell script that executes on a scheduler job daily to extract the Power BI audit log records and writes them to a file on a shared folder where they are picked up for processing. Note, sometimes it takes more than 24 hours before the audit data is available so we had to code around this to allow for a flexible lag.
We then wrote a custom Power BI report that joins the account information pulled from these audit logs to internal data sources so we can show data at multiple levels to track usage and adoption - by department, by title, etc.
