Forum Discussion

tkboisvert's avatar
tkboisvert
Icon for Helper II rankHelper II
5 years ago

SnowFlake: "native queries aren't support by this value"

Hi All,

 

When attempting to query snowflake with a native query, I get this error:

 

 

These are the parameters:

 

 

I have verified the credentials / tables /  databases / schemas are correct by connecting to directly to one table at a time, but simple queries like the screenshot and complex queries all return this message "native queries aren't support by this value".

 

I know this is a new feature ( June 2021 ) and I have read the documentation here: https://docs.microsoft.com/en-us/power-query/connectors/snowflake#connect-using-advanced-options

 

Any help is appreciated.

 

 

 

Need Help

9 Replies

  • YMadden's avatar
    YMadden
    Frequent Visitor
    4 years ago

    I was getting this same error on a complex (150+ line) Snowflake query in Power BI desktop, even after upgrading to the latest version (2.98.1004.0). Fully qualifying the table names as dbname.schemaname.tablename resolved the issue for me.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Use the Fully Qualified names like DBName.Schema.table. It worked for me 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi tkboisvert ,

     

    Please try to delete the data source on Desktop and reconnect to check whether the SQL statement is written correctly. You can clear the data source in Data source settings.

     

     

     

    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.

    • tkboisvert's avatar
      tkboisvert
      Icon for Helper II rankHelper II
      5 years ago

      Thank you for your reply, this did not resolve my issue.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hello,

     

    I have found that with new version i have missing driver for SnowFlake in PowerBI installation.

     

    Version:

     

    C:\Program Files\Microsoft Power BI Desktop\bin\ODBC Drivers\Simba Snowflake ODBC Driver

    MS team forgot to add: SnowflakeODBC_sb64.dll

     

    I have copied from other maschine that had previous version of PowerBI Desktop. And it worked.

     

    Best Regards

    A.K.

  • sanlavilleremy's avatar
    sanlavilleremy
    New Member
    3 years ago

    I had this same error message, it was caused by the fact that the Snowflake credentials didn't have SELECT access to one of the tables in my query.