The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
I am still looking for a way to monitor Report Run times in Power BI. I came across log analytics as being a way to do that. But as we have an onpremises SSAS Cube i was wondering if it is still possible. If it is not what other way can i actually monitor report run times in Power BI when using an SSAS Cube? This is extremely important for my company as otherwise there is no real way to monitor the Performance of Reports day to day. And before anyone says use perfomance analyzer in desktop. I do it but its not really a solution for day to day monitoring.
"What made me unsure about it is the following which is on the microsoft Website:
Activities are only captured for semantic models physically hosted within the Premium workspace where you configure logging. For example, if you configure logging for Premium workspace A, you won't see logs for any reports within that use semantic models hosted in Azure Analysis Services/SSAS
Can someone support on this topic?
You may want to look at SQL Server Profiler instead.
Yes. I can see the Queries and their run times. I can get the queries for a period using extended events. But there is no way to actually relate it to which report the Query is coming from or am i missing out on something? Is there a way to make a connection from SQL Server Profiler to a Report in a Service? If there is one i would really appreciate it if you can push me in the right direction. Is the ReportID GUID visible or not in SQL Server Profiler? I havent find it but would love to be told that im wrong