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 …