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...
Ran into the same problem, saw your post, then found this resource which documents the problem in a very detailed manner: https://cbailiss.wordpress.com/2022/09/03/power-bi-nullable-column-merge-join-problems/. No solution though.
Yesterday I worked with an old dataset/sematic model, without a workaround in place for this issue (it did nevertheless work because there was less data involved) and noticed that the (preview) data appeared rather quickly. After further examination, it appears that even though PowerBI still produces the same inefficient query, Snowflake seems to handle it fine now. Could be a workaround on their side?
Could it be that you have a PRIMARY KEY hint in the Snowflake table?