IssueTracker

Hi,

Description of the problem
When we are trying to connect a Big query table with Looker, some fields are not working properly.  We created a big query table

SELECT * FROM `optimax-build1.chocky_chocolate_shop_v2.optimax_abcd` LIMIT 100;

Please see the results from the table here


What part of the product are you having trouble with? Pick all that apply:

Data visualization / Charts

Filters

Data issues / discrepancies

Symptoms
Some key fields such as

Optimax-CLTV-segment
Optimax-propensity-segment
optimax-A
optimax-B
optimax-C
optimax-D
need to be read as categorical fields to build pivot tables, graphs etc. When we are using these fields, we are getting errors, although they seem to be fine on the big query table schema.


             Optimax-CLTV-segment
STRING  NULLABLE        -       -       -      
-
-
propensity_score
FLOAT   NULLABLE        -       -       -      
-
-
Optimax-propensity-segment
STRING  NULLABLE        -       -       -      
-
-
optimax-A
INTEGER NULLABLE        -       -       -      
-
-
optimax-B
INTEGER NULLABLE        -       -       -      
-
-
optimax-C
INTEGER NULLABLE        -       -       -      
-
-
optimax-D
INTEGER NULLABLE        -


These fields were generated using AutoML in prior steps. All the tables and charts show system error when trying to use these fields.  

Error ID : d306fe2c
 


Error message
Looker Studio has encountered a system error.

Sorry, we encountered an error and were unable to complete your request.


How widespread is the problem?

The problem happens on all my reports

Frequency
How often does the problem occur?

Always: The problem happens every time

Severity
How serious is the problem for you?

Major: It's a critical problem for me, with no workaround

Impact
How does the problem affect your ability to meet your goals using Looker Studio?

High: The problem makes it impossible to achieve my goals

Timing
If things were working, then stopped working, when did the problem begin?

How to reproduce the problem
Help us reproduce the problem by providing as much information as you can, including, if possible:

Step by step instructions on how cause the problem

An example report that demonstrates the problem

Video screencast or screenshots that show what's happening on your screen

Steps to reproduce the problem
1.   SELECT * FROM `optimax-build1.chocky_chocolate_shop_v2.optimax_abcd` LIMIT 100;

2. Input the above table into LookerStudio

3. Try creating pivot tables or charts using the variables

Optimax-CLTV-segment
Optimax-propensity-segment
optimax-A
optimax-B
optimax-C
optimax-D
Screenshot or Video
image.png


Connectors used
BigQuery

Best Regards,