Native Power Bi services snowflake driver

[JFL92]

Hi

We have been notified by snowflake that odbc drivers below 2.24.7 will no longer be supported at the end of April 2024

Connections from our power bi services use the snowflake native connection, which is identified by snowflake as odbc 2.24.6.

How can I please update this powerbi services infrastructure so that the native connector is up to date?

Thanks JF

[AniketMulay]

Hello!!

Has someone got any updates from Microsoft around this ?

BR

Aniket

[wjkolesar]

No updates here - I can still see Power BI service is still using verison 2.24.6 version of the ODBC driver 😞

[scottp]

We are having same dilema with the Snowflake ODBC driver in PBI Service. We configured our PBI desktops to use the latest Snowflake ODBC driver yet we cannot change the Snowflake ODBC driver used by the PBI service.

Not good.

We have compliance protocols placed upon us as well and thus require the PBI Service to be using the latest ODBC drivers for all connections.

[ked]

@JFL92  @david-ri 

Hi,

Has anyone received updates on this?

Our Snowflake query history still references v 2.24.6 of the ODBC driver.

Thanks for any info you can share.

[david-ri]

Here is the initial feedback I've had from Snowflake, with a promise to follow up again in a few more days

> [...] after checking with internal resources I can confirm that Snowflake is already aware of this situation and working towards a resolution with Microsoft. At the end of the day, however, it is a Microsoft product decision which drivers to bundle within their tools. Note that while the driver version 2.24.6 will not be supported by us, you will still be able to use the ODBC driver [...]

What makes things difficult is I have to meet internal controls around unsupported driver usage; strictly speaking, from end of April we won't be allowed to use PowerBI with Snowflake, as we'll be in breach of those controls.

[david-ri]

I've raised a support ticket with Snowflake, and given our account team a nudge as well ... going to have more success if Snowflake just take it up with Microsoft directly

[david-ri]

@v-yilong-msft , I don't think this addresses the issue.

The issue is that Microsoft uses an ODBC driver to connect to Snowflake for both the desktop application and the 'Cloud Connection' service, but the version used is out of date, and will be unsupported from 30th April 2024.

Correct me if I'm wrong here, but as far as I'm aware, the end user has no control over the version of this driver Microsft is using, and sure that is especially true for the PowerBI Service. Yet our logs show the PowerBI Service specifically is still using 2.24.6.

[JFL92]

Hi Zhou,

Thanks for yopur answer but in fact, my trouble is more that I have just downloaded again the most recent version of the driver provided natively by microsoft to access snowflake via power bi

And once again, it appears in the logs as 2.24.6, which is confirmed in the details of this driver

On the other hand, the last update indicated is very recent (19/02/2024) and I find it hard to believe that this is an obsolete version supplied by microsoft.

I would therefore like to know if the odbc driver referenced in the snowflake e-mail i received last week as all snowflake users, (the one we download from snowflake drivers site  i think; the most recent version seems to be 3.2.0 snowflake64_odbc-3.2.0.msi of 2024-02-01 ) corresponds to the one supplied by microsoft or if microsoft is upgrading its own driver and there is therefore no impact for powerbi users ?

Many thanks

JF

[v-yilong-msft]

Hi @JFL92 ,

As a global admin, sign in to Power BI. Go to Settings from the page header menu, then select Admin portal. Under Tenant settings, locate Integration settings. Expand Snowflake SSO, toggle the setting to Enabled, and select Apply. You can read this document for a further study: Connect to Snowflake with Power BI - Power BI | Microsoft Learn

Select the appropriate workspace, then choose Settings from the more options menu next to the semantic model name. Under Data source credentials, sign in using either Basic or OAuth2 (Microsoft Entra ID) credentials. By using Microsoft Entra ID, you can enable SSO for your semantic model.

You can Update Snowflake Connector Details.

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.