Forum Discussion

precisionandskl's avatar
precisionandskl
Frequent Visitor
1 year ago
Solved

Data source error: Value was not specified..

Hi. My refresh for a report keeps failing and returning this error. It refreshes fine in the desktop and what's more there are other reports published in the Service that use the same data sources an...
Need Help
  • precisionandskl's avatar
    precisionandskl
    1 year ago

    Ok, I've found the solution. Last month, I enabled the 'New Snowflake connector implementation' feature which is still in preview. The refresh obviously didn't like this! Anyway I've disabled it and all works fine now.

SUMESHKUMAR22's avatar
SUMESHKUMAR22
Helper IV
1 year ago

Hey precisionandskl , glad that I found your response. Could you please help me with were I can enable the "new snowflake connection implementation' feature??

Showing me below error when I removed the implementation 2.0 part from PQ :
DataSource.Error: ODBC: ERROR [HY000] [Microsoft][Snowflake] (4)
REST request for URL *** failed: CURLerror (curl_easy_perform() failed) - code=60 msg='SSL peer certificate or SSH remote key was not OK'.

Details:
DataSourceKind=Snowflake
DataSourcePath=uza80192.east-us-2.azure.snowflakecomputing.com;COMPUTE_WH
OdbcErrors=[Table]

Please help!

Thanks in advance!

precisionandskl's avatar
precisionandskl
Frequent Visitor
1 year ago

Hi - so I resolved the issue by removing the 'implementation 2.0' part in PQ like you've done. Then disabling the feature in Options > preview features. The error you get seems to be related to your company's firewall/proxy settings blocking the connection. If you refesh at home it should work ok.