Taking to long to Load rows

[Nidhi_Kochrekar]

Hi,

At first I merge two rows and extended 2nd table but it is taking forever to load Rows.

[v-jayw-msft]

Hi @Nidhi_Kochrekar ,

Take a look at the document about the Query Diagnostics in Power BI Desktop. It might help you check reason for the slow query.

https://docs.microsoft.com/en-us/power-query/querydiagnostics.

Also try to remove unused tables or columns, where possible.

Best Regards,

Jay

[amitchandak]

@Nidhi_Kochrekar , Change these parameters and increase memory management cache to 8-10 GB and try