Certificate Chain Not Trusted Error Effecting PowerBI Only

[heoliv]

Hi,

In a SQL query that I have run several times before I am not receiving the following error: 

Message=A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)

However, I am still able to access the databases that I receive this error for on PowerBI via SQL Server Management Studio. 

Does anyone have any insight onto why I would suddenly be running into this issue after not having issues with the databases effected before and how to resolve it?

[heoliv · Accepted solution]

This ended up being a fairly easy solution, in order to work around this issue I ended up just having to switch the connection type from MSFT account to Windows for any who encounter this issue in the future. 

[JJensen]

Holy hell!! I have a PBI-report that has been refreshing fine for 2+ years. It gets the occasional update in PowerBI Desktop and is republished. It just decided to not refresh this sql.datasource last week. Today I spent 3 hours on Google to finally find this solution.

Thank you for posting this! By now, this should be a suggestion in the connection error message.
My takeaway - If Microsoft can find a way to f**k up my day, they will! Otherwise they invent a new way!

[chomskyhonk]

Bless you for this.

[Syndicate_Admin]

Hi Syndicate_Admin,

I am having the same problem, before testing this workaround what are the implications of doing this on users trying to access the report across the network?.

Also do you have any idea what the switching to Oauth2 would do?

[powerbisofitec]

This worked for me too, thanks!