Forum Discussion
PowerBi Time Out error
I'm merging couple of objects in Salesforce, around half a million records. Worked fine until last merging but when I merged a csv with it & then expanded columns, it took lot of time & ultimately ti...
Hi. I'm sorry to say that power query merge operations have horrible performance :S
You may want to try some magic from Chris Webb blog. For example:
Hope that helps,
As per Chris's solution one Join columns should be already sorted. Not true in my case. Moreover its timing out during Expand Columns step.
