Forum Discussion
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 ?
17 Replies
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:29ZSo I conclude that...nobody has the same problem :smileyfrustrated:
Actually I am having the same problem! you are not alone! :D
Dear Team
I am getting below error while doing Scheduled data refresh in PowerBI Service
It was working fine till yesterday. Today morning I am getting this error
Also I manually did the refresh in PBIX file it is working fine however when we do scheduled refresh i am getting this error
Data source error: ERROR [HY000] [Snowflake][Snowflake] (25) Result download worker error: Worker error: [Snowflake][Snowflake] (4) REST request for URL https://fz9nkasfcb1stg.blob.core.windows.net/results/0192cf32-0046-3506-0000-3e6d022c59ee_0/main/data_0_0_2?sig=2J%2BSf5vqRUKjInsjJ1zywm%2FI0Zrfi2uqeYLv2Ewc%2B6o%3D&se=2020-03-12T07%3A15%3A04Z&sv=2018-11-09&spr=https&rsce=gzip&sp=rl&sr=b failed: CURLerror (curl_easy_perform() failed) - code=91 msg='SSL server certificate status verification FAILED'. . The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action. Table: CV_DT_MAINT_COSTS_UN.
Regards
Arun Hariharan
I created a seperate post for this SSL issue as I was having it yesterday and today. https://community.powerbi.com/t5/Issues/Snowflake-SSL-error-in-both-Power-BI-Desktop-and-Power-BI/idi-p/969540
