Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Yesterday morning (3/10/2020) data refreshes from Snowflake to both Power BI desktop and Power BI services started failing with an error message of 'SSL server certificate status verification FAILED'. We found it odd that when using Power BI desktop some smaller refreshes would work whereas the larger refreshes failed. A ticket was submitted to Snowflake to which they replied that they were having some issues on their Azure US-East 2 instance. Snowflake support explained that smaller workloads (say under 1000 records) are handled directly by their servers, whereas larger datasets are exported from Azure buckets, which would explain why the smaller imports were still working. They suggested we do several troubleshooting steps including the latest ODBC drivers. This seemed to conflict with other documentation suggesting that the latest version of Power BI desktop has the ODBC driver embedded. Note the failure seems to be timed with an update to the Power BI desktop that was automatically installed via the Windows store. Snowflake also suggested we start troubleshooting our network to see if we are blocking necessary ports.
Note that Snowflake no longer requires a gateway to refresh the data in the service. It seems to me if the Power BI Service which sits in Azure can’t refresh data directly from Snowflake (which also sits in Azure, but at a different data center for us), then the SSL failure must be an issue with Snowflake or Power BI and not our network. Also it seems that there have been others reporting this same issue.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.