How to Analyze Update Metrics in Semantic Model to Identify Slow-Loading Tables?

[Anonymous]

Hello,

I’m working with a semantic model and I’m looking for a way to analyze the performance of data updates. Specifically, I’d like to identify which tables are taking the longest to load during the update process.

Is there any built-in feature or tool that allows me to monitor and analyze the refresh metrics to pinpoint the slower tables? Alternatively, are there any best practices or recommended approaches for diagnosing and optimizing table refresh times in the model?

Thank you in advance for any guidance!

[Jonvoge · Accepted solution]

Hi MatheusLeite

You can use SQL Server Profiler to get a trace file with additional refresh details.

There is a neat guide here: Visualise your Power BI Refresh - Phil Seamark on DAX

_____________________________________________________
I hope my comment was helpful.
If your question was answered, please mark your post as 'Solved' and consider giving me a 'Thumbs Up'.
Find me on LinkedIn, Sessionize, or my blog Downhill Data

[Anonymous · Accepted solution]

Hi, @Anonymous 

Thanks for Jonvoge's reply. In addition to SQL Server Profiler, here are a few performance monitoring tools
1. Performance analyzer in Power BI Desktop
Use Performance Analyzer to examine report element performance in Power BI Desktop - Power BI | Microsoft Learn
Power BI Report Refresh Performance Analyzer - Power of Business Intelligence (powerofbi.org)
The refresh time of visual objects can be monitored as soon as the semantic model is created.

2. Diagnostics collection in PBI Desktop
Power BI Desktop diagnostics collection - Power BI | Microsoft Learn

3. SQL Server Profiler
SQL Server Profiler - SQL Server Profiler | Microsoft Learn

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[Jonvoge · Accepted solution]

Hi MatheusLeite

You can use SQL Server Profiler to get a trace file with additional refresh details.

There is a neat guide here: Visualise your Power BI Refresh - Phil Seamark on DAX

_____________________________________________________
I hope my comment was helpful.
If your question was answered, please mark your post as 'Solved' and consider giving me a 'Thumbs Up'.
Find me on LinkedIn, Sessionize, or my blog Downhill Data