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.
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.