Looker studio not reading a large number...

I am using a data source from a Google Sheet file.

I have a column with an ID that uses large numbers (9733491472046678906, 15750232142704111629, etc).

When I set up a table (chart), Looker Studio does not recognize it. It shows shorter numbers (3839070419, 8433604511, etc).

I tried treating the dimension (ID column) as text, but Looker Studio still does not recognize it.

Any idea why?

Solved Solved
0 4 165
1 ACCEPTED SOLUTION

Hello, I tried your example in my Google Sheets file, and it worked in my Looker Studio. May I ask how you connected it to your sheet? Also, what did you mean by 'Looker Studio doesn’t recognize it'?

_0-1743830768640.png_1-1743830782498.png

 

View solution in original post