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.
Is there a limitation on the number of dimensions that can be added to the tables of a blended data source?
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
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With