Forum Discussion
Dynamics CRM - PowerbI Desktop Hangs
Hi kharanadh,
Any advanced operation in query table or complex nested looping calculate formulas in your data model? They may cause duplicate spends on system resources and cause the freeze of proceedings due to large amount of calculation.
For this first scenario, you can try to add buffer function on these steps to reduce the duplicate memory resource spending.
How and When to use List & Table Buffer?
For the second scenario, you can take a look at how to optimizing these formulas to reduce the cost of memory resources. (notice: calculate amount will be multiplied with looping amount, e.g. iterate two tables with 10k rows will calculate 10k*10k=100 m) Optimizing nested iterators in DAX
Regards,
Xiaoxin Sheng
Super Userkharanadh , is it loading some data and hanging or just hanging on one table without loading.
amitchandak : Thanks for quick response.
1. data load takes lot of time
2. after data load I am creating relations and using matrix for visualisation there PBI completely hangs
some time system also hangs with this.
- amitchandak
kharanadh , refer if some of these settings can help
https://www.thebiccountant.com/speedperformance-aspects/
https://www.thebiccountant.com/2016/11/08/speed-powerbi-power-query-design-process/
Tried various below options but no luck
- 1. Removed unwanted columsns from each entity table
- 2. Merge mutiple tables in to single - loosing few columns values due to huge records
- 3. Same report works with 2,3 tables but not with all my 8 required tables
Hi kharanadh,
Any advanced operation in query table or complex nested looping calculate formulas in your data model? They may cause duplicate spends on system resources and cause the freeze of proceedings due to large amount of calculation.
For this first scenario, you can try to add buffer function on these steps to reduce the duplicate memory resource spending.
How and When to use List & Table Buffer?
For the second scenario, you can take a look at how to optimizing these formulas to reduce the cost of memory resources. (notice: calculate amount will be multiplied with looping amount, e.g. iterate two tables with 10k rows will calculate 10k*10k=100 m) Optimizing nested iterators in DAX
Regards,
Xiaoxin Sheng