Forum Discussion

james_mazzanti's avatar
james_mazzanti
New Member
2 years ago

What happened to Native SQL Query support for the Snowflake Connector? (December 2023)

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  

Need Help

2 Replies

  • edhans's avatar
    edhans
    Community Champion
    2 years ago

    Can you scroll down? I see this with Snowflake. December build.

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.