Forum Discussion
How to Analyze Update Metrics in Semantic Model to Identify Slow-Loading Tables?
- 1 year ago
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 - Anonymous1 year ago
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 Learn3. SQL Server Profiler
SQL Server Profiler - SQL Server Profiler | Microsoft LearnBest Regards,
Yang
Community Support TeamIf 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
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