Power BI Service ExecutionLog

[DSQU]

We are migrating hundreds of reports from a 2016 SSRS server to the Power BI service in Premium workspaces. One thing that was crucial for us in the old world, was to monitor report performance with the TimeStart and TimeEnd in the ReportServer database, dbo.ExecutionLog views. And also the using the TimeDataRetreival TimeProcessing and TimeRending fields. 

We are using the power bi admin APIs to get logs of users running the reports, and that includes the start time of the report running, but no EndTime. 

We also have the Fabric Capacity Metrics report but that doesn't seem to provide the detail we're looking for. 

Is there any way to measure how long an RDL report takes to run in the service, start to finish? we would also want this for a power bi report that for example uses direct query. 

[Anonymous]

Hi @DSQU,

Thanks for reaching out to the Microsoft fabric community forum.

It looks like you are looking for ways to monitor your report performances. As @Deku already responded to your query, please go through the provided response and mark it as solution if it solves your issue.

I would also take a moment to thank @Deku, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

If I misunderstand your needs or you still have problems on it, please feel free to let us know.  

Best Regards,
Hammad.
Community Support Team

If this post helps then please mark it as a solution, so that other members find it more quickly.

Thank you.

[Deku · Accepted solution]

Power BI has a integration with Log Analytics. This sends Analysis Services engine trace events, from connected Workspaces to Log Analytics.

Microsoft has provided the Fabric Log Analytics for Analysis Services Engine report template. This uses Execution Metrics Logs to provide reporting on CPU and duration metrics for operations performed by Semantic Models. Additionally Progress Report Logs are used to give addition details on Refreshes.

[DSQU]

Thank you Deku - i will review these links and dig in. It will take some times for me gain access to these products before i can fully confirm this satisifes our issue. Offhand, do you know if either of those solutions work with Paginated reports in the Power BI Service? i am mostly seeing semantic model metrics. 

[Deku]

Not 100% sure, can't see in the docs and have no paginated on my tenant to check