Forum Discussion
SnowFlake refresh problem
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
Thanks for posting a issue. I got same error since 3/10/2020.
Snowflake suggested using the latest ODBC driver with a DSN to fix the issue temporarily
We are in the middle of trying this solution. It isn't working out well. It requires us to change much of the development we have between our ETL product and Snowflake. The performance is horible. It then requires a gateway to refresh in the Power BI Service (recently a gateway was not requried by Snowflake). Also, this will all have to be reverted once the regular Snowflake driver works. This may be appropriate if you have a very small amount of tables, but otherwise it isn't great.
