Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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;
Solved! Go to 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...
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...
I don't want to use PowerBI dax, I want to use SQL query it self
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 63 | |
| 55 | |
| 42 | |
| 41 | |
| 23 |
| User | Count |
|---|---|
| 167 | |
| 136 | |
| 120 | |
| 79 | |
| 54 |