CODEWITHSUNDEEP
google-cloud-platformlooker-studio
davidbilla
davidbilla

Reputation: 2222

Data studio - cannot add more than 10 dimensions to a blended data source

I am trying to make a blended data source from 2 bigquery tables. The problem I am seeing is that I am not able to add more than 10 fields as dimensions in each table for the join.

As you can see in the image below, the Add dimension option is not available for the first table. If I remove one of these dimensions, I get the Add dimension option back.

enter image description here

Is there a limitation on the number of dimensions that can be added to the tables of a blended data source?

Upvotes: 4

Views: 4307

Answers (3)

PankajSanwal
PankajSanwal

Reputation: 1019

Google Studio does have limitations as stated in Docs here

Limits of tables

The number of dimensions and metrics you can add depends on the data source used by that table:

  1. Tables based on "fixed schema" data sources, such as Google Analytics, Google Ads, Display & Video 360, and other Google marketing products data sources can have up to 10 dimensions and 20 metrics.
  2. Tables based on "flexible schema" data sources, such as Google Sheets, BigQuery, and SQL databases can have up to 100 dimensions and 100 metrics.

Upvotes: -2

Luis Hernandez
Luis Hernandez

Reputation: 41

A solution (that i really don't like but works) is to add all the dimensions to the report attached to the datasource and not to the blend and then pressing "blend data" in the right panel. After this, in the bind creation view will appear the datasource that was attached before with all the dimensions that you added (it can be more than 10), but you will not be able to add more if the quantity of dimensions is greater than 10

Upvotes: 4

davidbilla
davidbilla

Reputation: 2222

The solution I found to this was to Add the same table again to the blended data source and add the remaining fields as dimensions. In my case, it was purchases joined with purchases.

I am not sure, if this is the right approach. I just want to know if this is a limitation from data studio?

Upvotes: 1

Related Questions