Unable to load the table data in data preview after clicking on transform data in power bi desktop.

[Anonymous]

Hi all,

When we click on transform data in Power Bi desktop refresh preview goes on forever. We are not able to do any changes in transform data.We are not able to load any table. Also to add the pbix size is around 700 mb.

 Any suggestions how we can fix this. Thanks in advance for the help.

Regards,

Omkar

[V-lianl-msft]

Hi @Anonymous ,

 If the dataset is large, we have to keep everything simple. For example,When you do joins/appends in Power Query it has to load the entire table into virtual memory. This causes a lot of paging and is very slow.

https://docs.microsoft.com/en-us/power-bi/guidance/power-bi-optimization 

https://docs.microsoft.com/en-us/power-bi/guidance/directquery-model-guidance#optimize-report-designs 

https://www.sqlbi.com/topics/optimization/ 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.