Cannot connect to cloud SQL

[JakeMcNally]

Hi

I am trying to connect to a cloud version of SQL for the first time but I keep getting the below error message:

I already connect to an SQL server without any issues but for some reason I cannot connect to a new server.

Details: "An error happened while reading data from the provider: 'Could not load file or assembly 'System.EnterpriseServices, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. Either a required impersonation level was not provided, or the provided impersonation level is invalid. (Exception from HRESULT: 0x80070542)'"

[Habarta]

none these very obsolete linked "solutions" solved the issue

[amitchandak]

@JakeMcNally , refer these solutions

https://natechamberlain.com/2019/02/12/power-bi-refresh-error-could-not-load-file-or-assembly-provid...

https://community.powerbi.com/t5/Desktop/Unable-to-connect-We-encountered-an-error-while-trying-to/m...

https://community.powerbi.com/t5/Desktop/Unable-to-Connect-to-SQL-Server/m-p/202262