topic Re: Troubleshooting visuals that take too long to load? in DAX Commands and Tips

Troubleshooting visuals that take too long to load?

Anonymous — Thu, 26 Aug 2021 08:58:50 GMT

Re: Troubleshooting visuals that take too long to load?

Tanushree_Kapse — Thu, 26 Aug 2021 10:50:54 GMT

Hi Anonymous ,

You may find this useful:

https://maqsoftware.com/expertise/powerbi/dax-best-practices

Mark this as a solution if I answered your question, kudos are always appreciated.

Thanks

Re: Troubleshooting visuals that take too long to load?

Alexrai — Fri, 27 Aug 2021 03:37:48 GMT

As well you can use Dax Studio to look at performance of Formula and Storage engines and isolate where the issue is comming from - there is also an "other" category for the wait for other visuals - Marco Russo shows in detail how this works here: https://www.sqlbi.com/tv/optimizing-the-distribution-of-distance-between-transactions-unplugged-21/

They also have a great video on optimizing card visuals somewhere on youtube.

Re: Troubleshooting visuals that take too long to load?

m3tr01d — Tue, 31 Aug 2021 12:04:07 GMT

Hello Anonymous ,

you can start by showing us a picture of your Data model with the relationship. Then show us the Dax code for each measures used in your Matrix (We also need the dependant measures).

Also, give us an idea of how many rows are we dealing with in your different tables used