Microsoft Power Query (Query folding)steps to sql query conversion

[Syndicate_Admin]

Hi Everyone, 

Is there any possibility to convert Power BI transform Query folding steps to SQL query conversion.

Thanks in advance 🙂

@amitchandak  @Tex Please assist here.

[BA_Pete]

Hi @Syndicate_Admin ,

To some degree, yes.

Assuming that your entire Power Query code maintains query folding, then you can right-click the final query step and select 'Show Native Query'. You'll need to adjust some of the shorthand that PQ uses, but you'll be 90% of the way there.

Pete