SQL query in Advanced editor for different data sources..

[Chennakesava458]

I have an issue i.e., A query in power query editor contains lot of predefined entities with different data sources and performed lot of transformations like merge, append, add columns and so on...

    Now Client requires to convert entire lengthy query into sql in advanced editor to decrease the load. Is it possible, if possible can you suggest how can we achieve this??

[Anonymous]

Hi @Chennakesava458 ,

@Anonymous Thanks for your concern about this case. 
Have you solved your problem? If not and if the datasource you use is relational databases, like SQL, you can click here to change the step in Power Query into SQL:

Here is an example:

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Sounds like you need to hire a consultant if you are getting paid by a client!

--Nate