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 …

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 …

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 …