Forum Discussion
Join Types not supported by Query Folding
I came across this issue today as well and found a surprising solution: https://www.thebiccountant.com/2019/04/18/query-folding-joinkind-inner-gotcha-power-bi-power-query/
I came across this issue today as well and found a surprising solution: https://www.thebiccountant.com/2019/04/18/query-folding-joinkind-inner-gotcha-power-bi-power-query/
Hi Imke,
Sorry I only saw your reply today. It is correct though, it does Query fold at the end!. The individual step itself still doesn't though, very odd. If creating the steps one by one this was an issue as it had to download all the rows before I could continue. Not sure whether to use inner joins with this issue or continue with left join, expand and filter. Will probably need to test which returns best performance.