If your data source schema is not set up correctly and you create/refresh a report in Google Data Studio then your data source schema is not able to connect to your data source and you see a data set configuration error with the following message: “Google Data Studio Cannot Connect to Your Data Set”
For example, consider the following Google Sheets data source:
Here, the field ‘Number of orders’ is of type ‘Number’.
But what if, when deciding the data source schema (structure), we set the data type of the field ‘Number of orders’ to ‘Text’ (instead of ‘Number’):
Once you set the data type of the field ‘Number of orders’ to type ‘Text’, you are telling Google Data Studio to expect values of type ‘text’ for the field ‘Number of orders’ when processing this field in the underlying data source.
Now when you create/refresh a report with the ‘Number of Orders’ field, Google Data Studio encounters a value of type ‘Number’ (instead of type ‘text’) in the data source.
Usually, Google Data Studio tries to convert values from one data type to another (like from ‘number’ to ‘percent’).
But sometimes it is not able to do that (like converting numbers to text).
And this is when your data source schema fails to connect to your data source and you see a data set configuration error:
So setting up data source schema correctly is critical.
