cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
FXFelix Regular Visitor
Regular Visitor

SnowFlake refresh problem

Hello,


I have created a report in PowerBI desktop, with an ODBC source connected to a SnowFlake driver.

Everything is ok in the desktop, the refresh take approximatively 1 minute for 570.000 rows.

Everything is ok when publishing the report, and I have created the SnowFlake datasource successfully on our Gateway.


I can see the report and the data is up to date on the PowerBI service, but when I try to lauch a refresh, the process is running again and again...


Anybody has the same problem ?

6 REPLIES 6
FXFelix Regular Visitor
Regular Visitor

Re: SnowFlake refresh problem

And here is the error message :

 

Un problème s'est produit
Impossible de se connecter à la source de données undefined.
Please try again later or contact support. If you contact support, please provide these details.
Code d'erreur sous-jacent: -2147467259 Table: WEATHER -- WEATHER_14_TOTAL.
Message d'erreur sous-jacent: ERROR [HY000] [Snowflake][Snowflake] (25) 
      Result download worker error: Worker error: [Snowflake][Snowflake] (4) 
      REST request for URL https://sccpb2sfcb1stg.blob.core.windows.net/results/018afe36-00e0-ab32-0000-0141000185ae_0/main/data_0_0_2?sig=wbr%2BUhAwyim51YFd1Y1LGUMcrzusybojmtSsyIIPErk%3D&se=2019-03-21T19%3A42%3A47Z&sv=2018-03-28&spr=https&rsce=gzip&sp=rl&sr=b failed: CURLerror (curl_easy_perform() failed) - code=91 msg='SSL server certificate status verification FAILED' osCode=9 osMsg='Bad file descriptor'.
    
    
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.ValueError.Reason: DataSource.Error
URI du cluster: WABI-NORTH-EUROPE-redirect.analysis.windows.net
ID d'activité: 0b125ce7-36c1-4963-a9a5-26b29d4d274f
ID de demande: c1132e48-76e9-604c-8cdc-99e089284d67
Heure: 2019-03-21 15:00:29Z
FXFelix Regular Visitor
Regular Visitor

Re: SnowFlake refresh problem

So I conclude that...nobody has the same problem Smiley Frustrated

Jmenas Member
Member

Re: SnowFlake refresh problem

Actually I am having the same problem! you are not alone! 😄

FXFelix Regular Visitor
Regular Visitor

Re: SnowFlake refresh problem

Thanks @Jmenas 😉

To be honest, I have gave up a few months ago.

But I will try again (for real) in a few months.

Jmenas Member
Member

Re: SnowFlake refresh problem

@FXFelix Do you have more than one data source or do you know if the gateway is updated? I have the issue but PBI support suggested that can be that the gateway is the issue, rather than snowflake it self. 

FXFelix Regular Visitor
Regular Visitor

Re: SnowFlake refresh problem

Hi @Jmenas ,

 

I had updated my gateways recently (august version), but I'm sorry, I can't test Snowflake datasets's refresh for the moment (billing problems with Snowflake...).

Maybe in a few weeks, i'll let you informed.

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)