Snowflake Conector 2.0 Preview - January 2025

[dgwilson]

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 - see the end for the update to the connector
https://learn.microsoft.com/en-us/power-query/connectors/snowflake

I have set the preview function to ON, and have restarted Power BI Desktop.
The documentation says to pickup/use the new connector you inject Implementation="2.0" into the Snowflake.Databases M code.
Source = Snowflake.Databases("contoso.snowflakecomputing.com", "CONTOSO_WH", Implementation="2.0")

I've done this, and in my case I have parameters for the Snowflake Address, Database, and Role
Source = Snowflake.Databases(SF_Address,SF_Warehouse, Implementation="2.0", [Role=SF_Access_Role]),
... it doesn't matter if Implementation is before or after the Role - I get the same error.

I'm getting the following error
Expression.Error: The import Implementation matches no exports. Did you miss a module reference?

Any pointers from the team?

[rbriga]

The latest updates to the Snowflake 2.0 implementation (February-March 2025) seem to have fixed the duplicates issue.

[rbriga]

I had a major issue with the new Snowflake implementation.

It works fine in Desktop, but not in Service.

When using a native Snowflake query, I would get the expected number of rows, but with wrong data.

ID fields (long text strings) would replicate the same value on other, otherwise correct, rows.

Note that it's not row duplication. For example, suppose this is the correct query values:

Product_ID	Product_Name
aaaaaaaaaaaaaa	Apple
bbbbbbbbbbbb	Bannana
ccccccccccccccc	Cereals
dddddddddddd	Donut

 The Service refresh would return:

Product_ID	Product_Name
aaaaaaaaaaaaaa	Apple
bbbbbbbbbbbb	Bannana
bbbbbbbbbbbb	Cereals
bbbbbbbbbbbb	Donut

It was hard picking up the reason for this. Removing the Implementation="2.0" tag fixed the issue.

[dgwilson]

It's really important that goes as feedback to the Microsoft team. I'm not exactly sure how to do that... I do recall that there may have been a feedback either in Power Query somewhere or on the Web page with the release details. Yea - found it.  https://learn.microsoft.com/en-us/power-query/connectors/snowflake - that's the link to the Snowflake documentation. About half way down it tallks about the new connector and has a link for feedback - https://aka.ms/snowflake-connector-feedback - it's really important you provide this experience and direct feedback to the team.

[AntoineAB1]

Hello. I had the same issue and just found out it was coming from the parameter [Implementation="2.0"].

Any idea how to deactivate this default parameter?

[dgwilson]

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]

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]

[AntoineAB1]

Hello,

I'm not expert but that looks like some issue that people had with ZScaler? If your organization have ZScaler set up on your machines, you might want to look into the related topics.

[SUMESHKUMAR22]

@AntoineAB1 , thanks for quick support.

[AntoineAB1]

Thank you. that worked!

[AlexisOlson]

I tried testing this on a Gen 2 dataflow (rather than Power BI desktop) but it said Adbc isn't available in the current environment.

[Anonymous]

Hi @dgwilson ,

Thanks for reaching out.

I reviewed your post and I think you'v got the answers already.

Please accept the reply as solution, more people will benefit from it soon.

Best Regards,

Stephen Tao

[dgwilson · Accepted solution]

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]

It wasn't an install.
Another simple table is taking minutes to load... and that's just the preview.