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.
- 'Table data cannot be migrated, source table is empty' in Azure SQL migration wizard
- Design in Query Editor disabled for Azure databases
- Merge rows in a specific sequence in SQL (Azure SQL)
- How create external table in Azure SQL to access a table in local SQL Server on same subnet. Getting error on select
- The SELECT permission was denied on the object 'Users', database 'XXX', schema 'dbo'
- Unable to 'Deploy Database to Microsoft Azure SQL Database' from SSMS 20.2
- Azure blob-to-SQL automatic copy
- How to connect a Web App to a SQL database on Azure using Managed Identities?
- Intermittent exception against SQL Azure: Unknown error 258
- Difference between Azure database for MySQL and Azure SQL database
- I'm using SSIS in ADF to move .csv from a blob container to another and then ingest into a Azure SQL database. I get an assembly error
- Is there a way to ignore the "STATISTICS_NORECOMPUTE" clause when doing a schema compare in Visual Studio?
- How to use a bicep template to deploy a SQL Server with auditing to log analytics enabled?
- How to Rename a Azure SQL Server
- Provision new SQL Azure database into existing, non-terraform managed SQL Server instance
- "We're sorry, your sql database is unavailable" What does this mean exactly in Azure SQL?
- Bacpac vs dacpac for migrating database to Azure
- Azure Logic Apps: Set condition to False when SQL query returns no rows of data
- Sink not overwriting table with specified data types
- Azure SQL database backup?
- Azure .NET SDK: Scale Azure SQL databases through SDK
- EF6.5 SetExecutionStrategy vs SetTransactionHandler
- Creating External table in Azure SQL Database using ADLS2 Datasource
- Search a column in database
- How to reduce the no. of columns on join when accessing a navigation property?
- 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