Monitoring Report run times in Power BI at Near Real Time like SSRS

[BI-Nomad]

Hi,

Is there a way where i dont have to pay for Azure Log analytics and can actually get Report Runtime and CPU Time information across all workspaces. We have Premium per Users capacity within the Company. I would like a solution that is akin to the one available in SSRS which one can see in ExecutionLogs3 in the SQL Server. I would really appreciate it if someone can push me in the right direction with regards to it. It should be near real Time.

I already know about RestAPIs and Usage metrics ( which are useless for me as they give info only till yesterday). RestAPIs and AdminRestAPIs just give Info on Metrics which arent really what i want like how many users used the Report or how many reports are across Workspaces. Please PowerBI Experts help.

Best

[SaiTejaTalasila]

Hi @BI-Nomad ,

Whatever @lbendlin mentioned is the one of the option available . If you want to monitor and analyze the time taken by the dataflows you can check this one-https://learn.microsoft.com/en-us/power-query/dataflows/load-dataflow-metadata-into-excel-online

Thanks,

Sai Teja

[lbendlin]

@SaiTejaTalasila that's not monitoring - it only analyzes after the fact.

[BI-Nomad]

I am using Live connection and am connected to SSAS. That isnt an option for me. Thanks nonetheless for the answer.

Best

[lbendlin]

You would have to connect SQL Server Profiler to all your semantic models. 

If you had Premium capacities you would have gotten workspace level usage reports, but they are definitely not real time.

[BI-Nomad]

I have premium per User Capacity. Like i wrote above they only provide data till yesterday which is sort of useless when users are having massive performance problems.

With the SQL Server Profiler one can connect the XMLA endpoint of the Workspace and use it but its not the ideal solution. Plus there is no way to directly see which Report the slow running queries are coming from other than looking into the Report and use Performance analyser. One can maybe also run extended events and push the logs into an SQL Table but this is far from the ideal solution. 

I think the one stop solution for the ideal Logging information with Power BI could be Azure Log analytics. Maybe i need to do a feasibility study and relay the costs to the relevant people and maybe we can get a Log Analytics workspace. All the other solutions using RestAPIs, Powershell, Admin Portal are all nice solutions but they are not meant for Query and CPU usage information. 

Thanks for your reply nonetheless.

Best