How to connect Looker Studio to an Azure SQL database

Question

I am trying to connect Looker Studio to an Azure SQL database, which has been frustrating.

First, there is no dedicated Azure SQL connector, so I use the Microsoft SQL Server connector.

I have entered the required fields (for both the BASIC and JDBC URL methods)

required fields - BASIC

required fields - JDBC URL

I keep getting the error here: error message

Any help from someone who has successfully done this will be much appreciated.

Answer 1

Here is how I managed to solve the problem. Make sure that you allow the database to accept connections from Google Looker Studio IP addresses. Here is the link where I found these.

Note that this notation (142.251.74.0/23) is an address sizing range so you need to include the IPs from: 142.251.74.0 to 142.251.75.255

Similarly the (74.125.0.0/16) means the folliwing range of IP address: 74.125.0.0 to 74.125.255.255.

Additionally I left the port blank (1443 didn't work).

I was then able to browse my tables via Looker Studio:

Good luck.