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 V3.5.8 Released

Ameet Wadhwani Analytics Canvas Tool, Cloud, Google Data Studio

We are pleased to announce the release of Analytics Canvas V3.5.8 featuring another significant enhancement to our Google Data Studio Data Connector and more cloud quota across the board! Increased Quota On All PlansAs we prepare for the launch of Analytics Canvas Online we have changed the label on a key metric involved in cloud quota. Since the Online version …

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. We set out to address this problem with the latest release of Analytics Canvas.  We have effectively removed row limits on our Google Data Studio Partner Connector while delivering exceptional performance!Freedom from Row Limits in Google Data StudioAnalytics Canvas was among the …

Analytics Canvas Version 3.5.0 Released

Ameet Wadhwani Analytics Canvas Online, Analytics Canvas Tool, Google Data Studio

We are pleased to announce the release of Analytics Canvas Version 3.5.0!  In this release we’ve dramatically increased the limits on the size of Data Studio datasets, introduced append and incremental load functionality to Data Studio exports, and prepared Canvas Desktop for the introduction of Analytics Canvas Online.Append + Incremental Load = 2 Billion Rows in Google Data Studio!As Data …