Forum Discussion
Microsoft EmployeeUsage Metrics for Dashboard/Report Authors Feedback
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.
sirui_sun The Report Usage Metrics Report fails to load within our organisation. Especially the ViewsCount part of it just tries to load for 10 minutes, and then gives up with an 'out of resources' error message.
Are you still working on the performance?
I have the same problem, i cannot see metrict of use in any report.
