Forum Discussion
AndrewSikomas
7 years agoRegular Visitor
Performance Issues with Unpivot and Append Query
Hello everyone, First-time, long-time... I have a table that contains two Values (that would go in the Value field in a visual). I want them to be in the same column, and I can differentiate ...
- 7 years ago
It sounds like your query is folding at an inopportune time. Check out these two resources to see if you can tweak the query for speed.
https://www.mssqltips.com/sqlservertip/3635/query-folding-in-power-query-to-improve-performance/
https://blog.pragmaticworks.com/power-bi-checking-query-folding-with-view-native-query
kcantor
7 years agoCommunity Champion
It sounds like your query is folding at an inopportune time. Check out these two resources to see if you can tweak the query for speed.
https://www.mssqltips.com/sqlservertip/3635/query-folding-in-power-query-to-improve-performance/
https://blog.pragmaticworks.com/power-bi-checking-query-folding-with-view-native-query