Forum Discussion

FXFelix's avatar
FXFelix
Resolver I
7 years ago

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...
Need Help
FXFelix's avatar
FXFelix
Resolver I
7 years ago

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's avatar
FXFelix
Resolver I
7 years ago

So I conclude that...nobody has the same problem :smileyfrustrated:

  • Jmenas's avatar
    Jmenas
    Advocate III
    6 years ago

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

    • FXFelix's avatar
      FXFelix
      Resolver I
      6 years ago

      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's avatar
        Jmenas
        Advocate III
        6 years ago

        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. 

  • PAPutzback2's avatar
    PAPutzback2
    Helper II
    6 years ago

    I am having this error today. I have turned in a ticket at Snowflake. I have about 6 datasets that refresh at 5AM and 3 of them are failing. It makes no sense that some succeed and some fail.