Forum Discussion
TSQL to Power query 'M'
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.
Anonymous I am guessing you have TSQL code to connect and get data from SQL Server. If yes then why don't you use power bi default connector for SQL Server which lets you type in your TSQL code and query. That will also generate power query code for you automatically by using default connector.
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.