Existing table visual failed with the latest Power BI Desktop update

[jochungJE]

Hi, hoping someone can help me. 

I just upgraded my PBI desktop to the latest release (2.92.706.0 (21.04) (x64)).

Some of the 'Table' visuals that work perfectly until now stop working with the following error message, can anyone pelase advise where or how I should go about resolving this? Should I log a support ticket for this issue?

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.);The certificate chain was issued by an authority that is not trusted. The exception was raised by the IDbConnection interface.

[jochungJE · Accepted solution]

Hi @Anonymous  and @amitchandak . 

I have re-establish the data source again and seems to be working now. Thanks for both for your help with this issue. 

[Anonymous]

Hi @jochungJE ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your problem.

Best Regards,

Yuna

[Anonymous]

Hi @jochungJE ,

Do you connect to SQL Server as the data source?

Have you tried to change the account from organisation to windows authentication?

Please refer to these similar threads to troubleshoot the issue:

Solved: unable to connect to the sql server - Microsoft Power BI Community

Solved: Authentication options for SQL Server - Microsoft Power BI Community

Solved: DataSource.Error: Microsoft SQL: A connection was ... - Microsoft Power BI Community

Hope that's what you were looking for.

Best Regards,

Yuna

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@jochungJE , refer if these can help you to resolve this

https://powerbi.microsoft.com/en-us/blog/ssl-security-error-with-data-source/

https://community.powerbi.com/t5/Report-Server/PowerBI-connection-issue-The-received-certificate-has...

https://community.powerbi.com/t5/Power-Query/Help-please-SSL-Provider-error-certificate-has-expired/...