Forum Discussion
Query folding creates unusable queries in merge
We use Snowflake as a data source, which (unofficially?) supports query folding. This normally works, but when joining large tables via "Merge Queries" we keep running into the issue that the resulti...
Thanks for your reply. We do try to avoid them as much as possible, however currently there are situations for us where (IMHO) there's no alternative.
Also I assumed that it's actually less expensive (on the Power BI side) to do it this way, since the amount of data that is imported is sized down beforehand?
Before merging you should reduce the column count to the smallest viable amount. I believe the data has to be sized down. You could try to unpivot other columns that are not the merge column. I have always tried to Remove columns when it's possible (and they are not needed).