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
Has anyone noticed that the ability to specify a native SQL query has been removed from the "Advanced Options" section of the Snowflake connector? I've also noticed that I am unable to bring up the Native SQL query window in EXISTING reports that have snowflake Native SQL queries, but they still work (I just can't edit them) any longer. Editing is possible in Advanced Editor, however, all the line feed/break, and tab characters make it difficult to work with.
Was this an oversight? Documentation on Snowflake connector says Native Queries are supported, but what about the UI part of the equation.... anyone?
This is what my December 2023 PowerBI Get Data (PowerQuery) screen looks like now...
Databases that support Native Query in PowerQuery...
Import data from a database using native database query - Power Query | Microsoft Learn
I was looking for answers to this exact issue - I can see SQL statement field in Power BI Desktop, but not on Server - hope that helps.
Can you scroll down? I see this with Snowflake. December build.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingThe Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 19 | |
| 10 | |
| 9 | |
| 8 | |
| 7 |