Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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
User | Count |
---|---|
33 | |
17 | |
13 | |
10 | |
8 |
User | Count |
---|---|
51 | |
31 | |
24 | |
17 | |
15 |