Unable To Connect Azure SQL Database

[UncleLewis]

Hi all,

I signed up for a free trial for Azure, added a SQL Database and configured the firewall, but I am still not able to connect to the SQL Server (Direct Query or Import)

What might I be missing here?

thanks

-w

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)'"

[v-xicai]

Hi @UncleLewis ,

In your scenario, do you install SSMS on the same machine that has Power BI Desktop installed? If not, except the “allow access to Azure services” setting, please ensure that you have set up a firewall rule to allow Power BI Desktop to make a connection to Azure SQL.

Please upgrade the Power BI Desktop to the latest version 2.73.5586.1101 , and then try it again.

Best Regards,

Amy

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

[UncleLewis]

Thanks Amy,

SSMS is installed on the same machine as Power BI Desktop

I upgraded Power BI Desktop a few days ago so I am using version 2.73.5586.984 64-bit (Sep, 2019)

On the Azure Portal, I clicked on my SQL Database >> Set Server Firewall and under Allow Azure services and resources to access this server, I added my IP Address

Is there anything else I need to do?

Thanks

-w