PowerBI: Unable to connect with SQL database with Sept Update - Error during Pre-login handshake
I am all of a sudden getting an error on all of my reports connected to an external db using Windows creds. to login. This just started occuring 2 days ago and we have yet to resolve.
Error reads:
Microsoft SQL: A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: HTTP Provider, error: 0 - )
Any Help would be so greatly appreciated.
29 Comments
- musicbydannyd
Advocate IV
Allisond, I am experiencing same issue (SQL Server connection), but only with datasets using incremental refresh... same with you?
- geraneNew Member
I am also seeing this issue.
- Allisond
Advocate II
- musicbydannyd
Advocate IV
Allisond, ditto... removed inc. refresh and was able to republish to service. I hope MS has a fix soon!
- mhowardNew Member
For clarity, this issue isn't resolved - rolling back an update is a temporary workaround at best, and I'm not seeing a way to prevent automatic updates so it could happen again at any time. This issue is affecting multiple users on multiple PC's. I'm currently on Version: 2.85.681.0 64-bit (September 2020).
- jmalone
Resolver III
I am seeing this issue as well.
- AnonymousNot applicable
We're seeing this same error when attempting to refresh datasets in the Power BI Service via our On-Prem Data Gateway. Anyone found a workaround yet?
- Rafael_JAVNew Member
I've got the same problema here.
Cannot create a new visual due to this connecting issue to th SQL server database.
Version: 2.85.681.0 64-bit (September 2020)
Any workaraund yet?
- SuppRegular Visitor
Any news?
Same problem here with Version: 2.85.681.0 64-bit (September 2020)
connecting to sql server 2016
Manually reverting to august version can't be considered a workaround if the september update is still being pushed
- AnonymousNot applicable
Allisond How did you remove the update?
Do you have a saved copy of the earlier version?
Does anyone know how to disable this annoying monthly update thing?