Forum Discussion
External Tools
HI All,
How can i check my reports performance when i am restricted in downloading external tools due to company policy??
Thanks
Use Performance Analyzer in Power BI Desktop.
Optimize DAX and Data Model.
Reduce Data Load with Filters and Aggregations.
Disable Unnecessary Visual Interactions.
Monitor Report Size and Refresh Times in Power BI Service.
Leverage Audit Logs for Usage Insights
You can use Azure Log Analytic
Thanks,
Pankaj Namekar | LinkedInIf this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.
Hi Anonymous
This will be challenging without external tools. The best approach is to use Performance Analyzer. However, you’ll need to close and reopen your PBIX file, as re-running the same query in Performance Analyzer will retrieve it from the cache instead of executing it fresh.
Things I would check:
DAX formula that filter a table instead of just a specific column
DAX formula applied to high cardinality column
Datetime columns - split them into two separate columns to reduce cardinality and model footprint. Reduce precision - eg removing seconds - if not needed.
5 Replies
Use Performance Analyzer in Power BI Desktop.
Optimize DAX and Data Model.
Reduce Data Load with Filters and Aggregations.
Disable Unnecessary Visual Interactions.
Monitor Report Size and Refresh Times in Power BI Service.
Leverage Audit Logs for Usage Insights
You can use Azure Log Analytic
Thanks,
Pankaj Namekar | LinkedInIf this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.
Hi Anonymous
This will be challenging without external tools. The best approach is to use Performance Analyzer. However, you’ll need to close and reopen your PBIX file, as re-running the same query in Performance Analyzer will retrieve it from the cache instead of executing it fresh.
Things I would check:
DAX formula that filter a table instead of just a specific column
DAX formula applied to high cardinality column
Datetime columns - split them into two separate columns to reduce cardinality and model footprint. Reduce precision - eg removing seconds - if not needed.
Hi Anonymous ,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.Regards,
Chaithra E. Hi Anonymous ,
We wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.Regards,
Chaithra.Hi @gmandave1972 ,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.Regards,
Chaithra E.
