Forum Discussion
TSQL to Power query 'M'
Hello, I have made a query in Power BI Desktop (power query editor). Now I want to create another query based on that query. Since I am a beginner in Power Query I am not very good in 'M'. I do how...
Anonymous Create a new connection to sql server with TSQL code then view code of that under Advanced Editor and use that as a basis for your own query.
Hello Ankitpatira, thank you for your interest.
I cannot use the TSQL code and connect to the SQL server, because the code is from another SQL server, and I have made a query in Power Query that includes the data that I need. So I need to make a new query from that table.
Anonymous Create a new connection to sql server with TSQL code then view code of that under Advanced Editor and use that as a basis for your own query.