Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

PBI template/report for analyzing cube issues/refreshes/activity

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.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable

      Anonymous 

       

      Thanks for this but I'm talking about Analysis Services in Azure, not about Power BI.