Forum Discussion

dgwilson's avatar
dgwilson
Resolver III
1 year ago
Solved

Snowflake Conector 2.0 Preview - January 2025

Asking here if anyone else has had issues testing the new Snowflake Connector in the January 2025 release of Power BI Desktop? Version: 2.139.1576.0 64-bit (January 2025) Link to documentation - ...
Need Help
Tips and Tricks
  • dgwilson's avatar
    dgwilson
    1 year ago

    Answering my own question here... The syntax seems a bit different to the doc.

    [Role=SF_Access_Role, Implementation="2.0"]

    This 
    Source = Snowflake.Databases(SF_Address,SF_Warehouse, Implementation="2.0", [Role=SF_Access_Role]),
    becomes
    Source = Snowflake.Databases(SF_Address,SF_Warehouse, Implementation="2.0", [Role=SF_Access_Role, Implementation="2.0"]),


    It seemed very slow initially to retrieve a simple data set.
    2nd go was quite fast. I'll have to try another table now... there may have been a background install maybe?

     

     

dgwilson's avatar
dgwilson
Resolver III
1 year ago

If you do not want to use the v2 implementation by default - you are best to turn off the preview feature. Then for any given table, you will have to edit the M code in Power Query to remove the [Implementation="2.0"] parameter. That should make Power Query use the v1 connector.

SUMESHKUMAR22's avatar
SUMESHKUMAR22
Helper IV
1 year ago

Hi dgwilson ,
Im getting below error when I removed the 2.0 part from the power query.
let
Source = Snowflake.Databases("uyt10278.west-us-2.azure.snowflakecomputing.com","COMPUTED_WH"),
XHANCE_OPTINOSE_Database = Source{[Name="XHANCE_OPTINOSE",Kind="Database"]}[Data],
XHANCE_OPTINOSE_DEV__HARSHAD_PARDESHI_Schema = XHANCE_OPTINOSE_Database{[Name="XHANCE_OPTINOSE_DEV__HARSHAD_PARDESHI",Kind="Schema"]}[Data],
FCT_MEDIA_KPIS_View = XHANCE_OPTINOSE_DEV__HARSHAD_PARDESHI_Schema{[Name="FCT_MEDIA_KPIS",Kind="View"]}[Data]
in
FCT_MEDIA_KPIS_View
Error:

DataSource.Error: ODBC: ERROR [HY000] [Microsoft][Snowflake] (4)
REST request for URL *** failed: CURLerror (curl_easy_perform() failed) - code=60 msg='SSL peer certificate or SSH remote key was not OK'.

Details:
DataSourceKind=Snowflake
DataSourcePath=uza80192.east-us-2.azure.snowflakecomputing.com;COMPUTE_WH

OdrbcErrors=[Table]