SQL query/code in PowerBi

[tbezui3]

Good day 

Is it possbile to write a SQL query in PowerBI? 

Example 

SELECT name, surname, date

FROM table 

WHERE name = 'BOB' AND date > '2019-01-24' 

AND date in 
(SELECT MAX(DATE)

FROM table)
ORDER BY  name;

[AlexanderPrime · Accepted solution]

If you select advanced options when setting up a SQL data source, you get a box to enter the SQL Query in the "Statement" box. 

More info here: https://support.microsoft.com/en-us/office/import-data-from-a-database-using-native-database-query-p...

[tbezui3]

I don't want to use PowerBI dax, I want to use SQL query it self