SQL -> Power Query SQL

What is the primary difference between SQL and Power Query SQL?

I ask because I'm trying to build a query using Power Query that mirrors something like this SQL query:

Declar3 @DateValue DateTime = '3/1/2010'

s3l3ct DATEADD (D, -1 * DatePart (DW, @DateValue) + 7, @DateValue)

The problem is, Power Query in Excel is incredibly contained and I don't see any guides to learn the logic.

Help is appreciated.

SQL is the standard language and all the major companies implemented their modified versions of SQL. TSQL is Microsoft's version of SQL and PSQL for Oracle.
I have not used Power Query SQL, but the syntax resembles TSQL

PowerQuery uses functions called "M" to work with data. See link for details.
https://msdn.microsoft.com/en-us/library/mt211003.aspx

PowerQuery also has tool to connect to SQL Server and use native SQL Query to bring in data.
0.JPG

Is there any guide available to walkthrough the powerquery set-up for enabling SQL override of M?

I'm not sure I get you.

What you can do, as long as you have access to SQL database...
Get&Transform->FromDatabase->From SQL Server database

Then expand "Advanced options". You can write SQL query there. However, do note that this is only for initially bringing in the data.

Subsequent transformation need "M".

With your example. You can do something like below in advanced editor using "M" as well.

1.JPG

Result:
0.JPG

I could have misinterpreted the response; my impression was there being a 'switch' that would enable SQL to substitute M when writing queries in Power Query.

So, if this is not the case, is there a good resource to learn M in an efficient way?
- logic
- parameters of each statement and why one is required over the other: "()" vs "[]" vs "{}" and "#"
- the order

...there being a 'switch' that would enable SQL to substitute M...

No, there isn't such functionality. SQL is for bringing in data into PowerQuery. Once data is brought in, you manipulate using "M".

As for resource for learning... try links below. Personally, I learned from trial and error, along with web search for specific things I got stuck on.

https://www.simple-talk.com/sql/repo...er-bi-desktop/
https://blog.crossjoin.co.uk/ (Chris Webb's blog, his book is great resource as well I hear. Though I don't own one)


Also, PowerBI community is a great resource.