CODEWITHSUNDEEP
azurepowerbipowerbi-embedded
donquijote
donquijote

Reputation: 1812

Power BI Desktop cannot connect to azure SQL

I am trying to establish a connection to an azure SQL database from Power BI Desktop. I enter the server and database names as per the following screenshot:

enter image description here

I keep getting the following error:

enter image description here

Additionally, I am able to connect form the same Power BI Desktop to another azure SQL database on the same azure SQL server. I checked for typos, for the azure firewall settings including my client IP and for "Allow access to Azure services" set to ON. The fact that one of the databases in the same server is connecting correctly make me consider if there is a limitation on Power BI desktop to one only database per azure SQL server.

Upvotes: 1

Views: 4013

Answers (1)

donquijote
donquijote

Reputation: 1812

I was finally able to establish the connection with the azure SQL server by replacing Server field above with: tcp:myServerName.database.windows.net,1433 and leaving the Database field empty. This allowed me to connect to both databases in the server and didn't request credentials. Somehow power pi desktop was not letting me create a new connection to another database under the same server. This has not been made clear in Power BI desktop documentation and examples.

Upvotes: 3

Related Questions