Forum Discussion
Append Queries as New will result in no query folding
Dear fellow BI'ers, I have a really strange behaviour when appending queries as new. In my scenario, I have one source (SQL Server) to whom I connect. This source has several companies within...
Hey, im hijacking your question since im trying to replicate the query folding you did with "Append Queries".
I have two tables from one SQL server but two different databases.
For each query the query folding works. If i try to append the tables (like this: #"Appended Query" = Table.Combine({ThisTable, OtherTable}) query folding won't work from that point forward. Am I missing something or is it not possible?
Found the answer here:
https://community.powerbi.com/t5/Power-Query/How-to-Achieve-Power-Query-folding-with-Append-Quires/td-p/2243689