External Tools

[Anonymous]

HI All, 

How can i check my reports performance when i am restricted in downloading external tools due to company policy??

Thanks

[pankajnamekar25 · Accepted solution]

 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 | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.

[v-echaithra]

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.

[v-echaithra]

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.

[v-echaithra]

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.

[danextian · Accepted solution]

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.

[pankajnamekar25 · Accepted solution]

 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 | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.