How to connect Looker Studio to an Azure SQL database
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.
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.
- Creating External table in Azure SQL Database using ADLS2 Datasource
- Search a column in database
- sqlcmd fails with Incorrect syntax near ';' after upgrading to .NET 8
- ODBC Driver 18 Not Found in Azure Function Using Python 3.11
- SQL Post Deployment SQL CMD Variables and YAML Task
- 'dbo' user should not be used for normal service operation
- Logic App to call Azure SQL stored procedure passing datetime param
- How do I stop and start a SQL Azure database?
- How to react to message from Microsoft regarding updating API's
- Powershell - Connecting to SQL Server using Connect-AzAccount (With MFA)
- Why can't I use a Terraform `move` block to move an Azure SQL Database to a different resource name?
- Need help in understanding Select Within Select with Where
- Selecting last instance of a column, but comparing different column with CASE
- Clustered column store not aligning GUIDs to segments despite ordering
- How do you check the status of a SQL Import Export Operation in Azure?
- Unable to create stored procedure through Azure pipeline
- Can we recover a database from a deleted server in Azure SQL
- How to insert CSV file from Azure Repo to Azure SQL Database via Release Pipeline?
- How to connect to Azure pass DB from a secure network
- Perform an update to a value and use that value to update another value during the same update process
- Reach Azure SQL database with dynamic IP addresses
- Trying to connect to SQL DB - provider: TCP Provider, error: 26 - Error Locating Server/Instance Specified
- I want to fetch Azure SQL table data from ADF to use as input in copy activity
- The SELECT permission was denied on the object 'Users', database 'XXX', schema 'dbo'
- Azure SQL analysts can create views from forbidden cross database data
- Stream Analytics doesn't output the data to SQL but does to a blob storage
- Langchain cannot connect with Azure SQL Database
- Automate-Azure Active Directory Group Export to Azure Data Lake
- Copy Database - Performance
- Does the performance of inserting data into Azure SQL database from Databricks affected by the sizing of the database?