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
I’m trying to establish whether the PBI Impala datasource supports the use of a SQL statement.
The UI doesn’t appear to provide an option to specify SQL, but wondering if it’s possible via M syntax in the advanced editor (again no docs)
This is certainly possible via the Impala ODBC driver, so I’m wondering why not via native?
@wrathbon,
It doesn't support to write SQL statement via M or UI when using Impala connector, about this issue, you can submit a feature request in Power BI ideas forum.
Regards,
Lydia
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!