why looker studio report shows error if i adjust the formula in my connected sheet.

hi

      i had created near about 30 reports. all was working fine. but i adjusted the formula in my google sheet and now not any single report is working. how frustrating is this. i have tried many options but not able to get it back as before. i had adjusted the formula in Column H now as i remove column H filter from report my report satrts to show data but as i select column H in filter it starts to show error. i have tried to reconnect also but nothing is working.if there is some way please tell otherwise i will have to make all of those reports again and in future if there any adjustment in google sheets then also there will be same issue.

Sanziiv_0-1729250806007.png

 

0 3 939
3 REPLIES 3

Sorry that you are having trouble! Have you tried refreshing the data source fields? 

https://support.google.com/looker-studio/answer/7083608

You'll want to refresh the fields whenever you make changes to your underlying Google Sheet.

i have tried this.

refreshing datarefreshing data

and i deleted the data source in resource>manage data sources and then reselct my whole sheet named "master" but it is not taking up that column in which i had adjusted the formula. i had deleted all the reports but afyter your reply i just restored and tried but still not working. the data in the screenshot is being seen becuase i have removed the filter from the report for that column and after reconnecting that column has disappeared from the report. filter started to show red so i removed the filter and it is not taking up the specific range also which can be seen when we click on add data in data pane. (beside the add dimension.)

the answer link you have provided me i have read there that we can make a data  refreshing button with connected source sheet. can it solve the issue. and i will need to be guided to make that refresh button connected with my sheet. i am using looker studio for first time.