When combined with non-SQL-datasources query-folding will often not work: http://www.thebiccountant.com/2017/07/20/sql-query-folding-bug-still-alive-sucking-powerbi-powerquery-excel/ This is rea...
v-qiuyu-msft
Community Support
Community SupportHi ImkeF,
Please see below response from PG:
This is currently by design. We have heuristics around how to perform heterogeneous joins which we have no interest in changing at this time. Consider filing a suggestion at ideas.powerbi.com for generic improvements to and/or control of heterogeneous joins.
Best Regards,
Qiuyun Yu