Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
fake Codes likely:
let table1 = sometableInSameQuery, table2 = anotherTableInSameQuery, #"Added Conditional Column" = Table.AddColumn(table2, "new column", each if [C1] = null then table1{[C1=[C2]]}[C3] else [C1]) in #"Added Conditional Column"
table2 has 5000+ rows, table1 has 800+ rows, content of table1 is gotten from JIRA REST API.
when apply changes, I found both table1 and table2 can be loaded very quick. But the new query loaded very very slow. Why? I am wondering if table as function parameter consuming resource too much? Or does JIRA REST querying need every time when Table.AddColumn executed row by row?
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
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/5... 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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.