How (not) to break Power BI Query folding by changing data types!

Changing data types is one of the most common transformations in Power Query/Power BI. Learn how one subtle difference can (not) prevent the query from folding, and consequentially have a huge impact on your Power BI report performance!
Blog post: data-mozart.co...
Blog post 2: data-mozart.co...

[@nickcorbin7303]

Really useful, i'd always wondered why sometimes the total rows imported were way in excess of the final number.

[@DataMozart]

I assume that's probably because your query was not folding, or partially folded at best. Once you determine the step that prevents query from folding, try to move it down the transformation pipeline as much as possible

[@harshagraj]

Very useful!! Thankyou.

[@DataMozart]

You're welcome, I'm glad to hear that!

[@Brunietoons]

Hvala!

[@DataMozart]

Nema na cemu;)