Looker studio not fetch all columns from google sheets

Hi,

I made a looker studio dashboard by using google sheet as a data source. There are 25columns in google sheets (A to Y) but looker studio fetch only 24nos column (A to X). Data studio not fetched the Y column even after it has a unique column header.

Note: When i have deleted the X column data intentionally then the Y column data replaced in X column data. Then it fetched by looker studio. It means looker studio only able to fetch 24nos column.

So let me know how to solve this issue.?

I’m not sure what’s going on in your case, but I did want to confirm that there is not a 24 column limit in Looker Studio. I uploaded a google sheet and was able to successfully get all 26 columns.

Do you still see this problem on a fresh/test google sheet with more than 24 columns? There must be something else specific about your sheet that is causing this cutoff.

After i remove the google sheet as a resource and add the same sheet. Then i move the last column position to first. After that it works fine.

It’s strange.

very weird. Glad you were able to work around it!