Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Velkins
Frequent Visitor

Power BI - Snowflake Private link through Gateway

We have a PowerBI Service Gateway installed on a Windows EC2 inside of our VPC that is able to communicate to the Snowflake VPC. Following this document here: link.

 

We have the Snowflake ODBC driver installed on this machine and have tested its connectivity to Snowflake on the 32 & the 64 bit odbc driver and we are on the most recent version of the ODBC driver. Everything is working when we create the connection to Snowflake in the PowerBI service and test it. The problem arises when we use the Gateway Connection in PowerBI to pull data and refresh. Upon refreshing, we get the following error: ERROR [HY000] [Microsoft][Snowflake] (25)      

 

Result download worker error: Worker error: [Microsoft][Snowflake] (4)      

REST request for URL https://sfc-va3-ds1-6-customer-stage.s3.amazonaws.com/gbv00000-s/results/01a9b1dd-0004-3b1e-0013-d10...  failed: CURLerror (curl_easy_perform() failed) - code=2 msg='Failed initialization'. DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259 Microsoft.Data.Mashup.ValueError.Reason: DataSource.Error Cluster URI: WABI-US-EAST2-C-PRIMARY-redirect.analysis.windows.net Activity ID: d60cd747-0061-4d64-80da-2e9865adac11 Request ID: ad243ad2-db7a-b6d3-0bff-f29160fe8c30 Time: 2023-01-16 20:42:52Z

 

Are there any special considerations we may not have been informed about regarding connecting to Snowflake through the PowerBI service through AWS Privatelink?

 

There is an article from Feb 2020 saying the PowerBI service may not work with Privatelink and I've attached that here: https://www.snowflake.com/blog/using-sso-between-power-bi-and-snowflake/

1 REPLY 1
Logendran_M
New Member

Hello everyone, 

 

I too need the solution for the above query. if anyone works with snowflake gateways, please share your working method. 

 

Thanks

 

M Logendran

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors