Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

why function taking table parameter runs so slow?

Hi,   fake Codes likely: let table1 = sometableInSameQuery, table2 = anotherTableInSameQuery, #"Added Conditional Column" = Table.AddColumn(table2, "new column", each if [C1] = null...
Need Help
v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

Hi Anonymous ,

Normally the performance may be caused by many factors. I'm afraid that your issue may caused by refering other queries.

You could refer to this similar thread firstly.

In addition, I'm not good at the performance for power query, hope ImkeF could give further advice for your scenario.

Best Regards,

Cherry

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

hi,

v-piga-msft, thanks for help!

 

 

After some google for instance , https://powerpivotpro.com/2017/07/power-query-refresh-speeds-suck, I firmed my guess about Power Query poor perfermance. 

And inspired by https://community.powerbi.com/t5/Desktop/Transformations-in-Power-Query-Very-Slow-Performance/td-p/584292.  Using DAX in lieu of Power Qurey M solved the pain.

 

But I still can not sure where power query perform so poorly, I suspect power query go to do JIRA request row by row. 

Regards