cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

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 however have the query code in TSQL.

 

As far as I can understand, I cannot use TSQL to create a new query in Power Query...?

What is the best way to use/convert the TSQL code?

 

Thanks,

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

@Chewbacca 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.

View solution in original post

4 REPLIES 4
Highlighted
Community Champion
Community Champion

@Chewbacca 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.

Highlighted

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. 

Highlighted

@Chewbacca 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.

View solution in original post

Highlighted
Microsoft
Microsoft

Hi @Chewbacca,

What specific data do you want to get with the new query? You can review the following blog and article to get details about that how to retrieve or transfer SQL Server data with Power Query Formula Language.

Power Query Formula Language in Power BI Desktop
Power Query (informally known as "M") formula categories

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors