Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi there.
Guys, I've got a cube in Azure and would like to analyze its refreshes and/or activity. I also have logging enabled on it so that logs and counters go to a Log Analytics Workspace in Azure (this is queried via the Kusto Querying Language but it's of no importance here). These logs are what you would get from SQL Server Profiler or xEvents if you'd set it up on-prem. The question is this: Does anyone of you know if there is any PBI report somewhere I could download and connect it to my logs to (or even pre-processed logs) so that I could have ready-made, so to speak, visualizations of my counters and events on the server? I wouldn't like to create this myself since it'll take a lot of time (but certainly doable). Do you, guys, know about any tool that could take the logs, do some cleaning on them and then put in a .pbix file for analysis?
Thanks for any replies.
Hi @Anonymous
I think you can try to get Power BI logs from Audit Log in admin 365. You can choose the logs you want , download them as excel and load excel into Power BI Desktop for analysis.
You need to be a Global Admin or Power BI Service admin to use Audit logs.
You can search logs you want by entering key words into activities.
For reference:
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-auditing
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |