Hi @Olenard ,
The following Power Query connectors support native database queries.
| Connector |
Type of native database query |
| Azure Analysis Services database |
MDX or DAX query |
| Azure Database for PostgreSQL |
SQL statement |
| Azure Cosmos DB |
SQL statement |
| Azure SQL Data Warehouse |
SQL statement |
| Azure SQL database |
SQL statement |
| DataWorld.Dataset |
dwSQL |
| Essbase |
MDX statement |
| FHIR |
FHIR Search |
| IBM Db2 database |
SQL statement |
| IBM Informix database (Beta) |
SQL statement |
| MySQL database |
SQL statement |
| ODBC |
SQL statement |
| OLE DB |
SQL statement |
| Oracle database |
SQL statement |
| PostgreSQL |
SQL statement |
| SAP HANA database |
SQL statement |
| Snowflake |
SQL statement |
| SQL Server Analysis Services database |
MDX or DAX query |
| SQL Server database |
SQL statement |
| TIBCO(R) Data Virtualization (Beta) |
SQL statement |
| Vena (Beta) |
Model Query (MQL) |
For more details, refer to https://docs.microsoft.com/en-us/power-query/native-database-query#connectors-that-support-native-da...
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
