Unable to Connect we encountered an error while trying to connect with Microsoft SQL

Hi Tanuja_PBI ,

According to your description, my suggestion is: in the latest version of powerbi desktop,In data source setting, you can try to remove the existing connection for SQL server and try one more time. You can also set the permission level while editing the data source.

Or see if similar posts are helpful to you.

A connection was successfully established with the server, but then an error occurred during the login process. (Error Number: 233) - Stack Overflow

"The certificate chain was issued by an authority that is not trusted" when connecting DB in VM Role from Azure website - Stack Overflow

Best Regards,
Henry

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