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.
Hi Anonymous,
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