6 Ways to get data from SQL Server into Google Data Studio

Ameet Wadhwani Google Data Studio Leave a Comment

In late September 2018, Google announced that Data Studio had moved out of beta and into to general availability.  Millions of people have used Data Studio since the beta launch in 2016, and there’s an even bigger group of people who would use Data Studio, if only they could connect to their SQL Server databases with it.Update February 2022Google has …

How to get ALL your Data and Exceptional Performance in Google Data Studio

Ameet Wadhwani Google Data Studio

Many people are concerned about Google Data Studio row limits and are struggling with slow reports as they add more data. As Google Marketing Platform Technology Partners and with many customers experiencing this problem, we set out to address it.  The result?  We have effectively removed row limits on our Google Data Studio Partner Connector while delivering exceptional performance!Overcome the …

Missing data in Google Data Studio when using database connectors

James Standen Google Data Studio

When using Google Data Studio database connectors you might see data missing for a given date range, or incorrect totals in scorecards and graphs. In this post, we look at why data is missing in Google Data Studio reports when querying against SQL Server, MySQL, Postgres, and other database connectors.  We also show you two different methods to ensure all of …

How to load more than 150K rows from SQL Server to Google Data Studio

James Standen Google Data Studio

It is possible to load more than 150k rows from SQL Server to Google Data StudioIn this blog post, we’ll explain how you can avoid hitting the 150,000 row limit in Google Data Studio when you have large data sets in SQL Server.  We’ll give you a heads up on how Data Studio will actually show incorrect data if you …

How Google Data Studio Connects to Databases and How to Resolve Connection Issues

James Standen Google Data Studio

In this post we look at how Google Data Studio connects to your database, what causes the myriad of database connection errors that users come across, and offer solutions on how to resolve them.  To demonstrate how the connection process works and what was causing these errors, we ran a series of tests.  Later in the post we explain how …

Analytics Canvas Online revealed at SheetsCon 2020

Ameet Wadhwani Analytics Canvas Online

Imagine Google Sheets without cell limits and BigQuery without SQLAs a data-prep tool with lots of connections into the Google ecosystem, we have quite a lot of customers using Google Sheets together with Google BigQuery, Google Data Studio and a number of other data sources. So we were delighted when we heard that Ben L Collins, a Google Developer Expert …

Connecting Google Data Studio to a Database? Avoid These 3 Serious Challenges

James Standen Analytics, Google Data Studio

Data Studio makes great looking reports and dashboards, and at a price point of free for everyone, Google is obviously making it easy to afford.  But many organisations find a number of key challenges and “connection does not exist” errors when connecting Google Data Studio to a database. Also, if you’re interested, you can read more about all the ways you …

ETL Google Analytics data into your data warehouse

Ameet Wadhwani Analytics Canvas Tool, Google Analytics API

There are lots of good reasons to pull Google Analytics data into spreadsheets or databases for reporting and analysis.  You can get rich details not available in the web interface, you can blend it with internal data sources, you can extract large volumes of unsampled data in bulk, and so much more. For these reasons, Google Analytics APIs have been …