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

[Sanziiv]

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.

[Rick_E]

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.

[Sanziiv]

i have tried this.

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

[Sanziiv]

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.