I've messed something up with datasource connection while working on extract ..
now trying to connect it all and have error message:
An error occurred while communicating with the data source.
Bad Request: The data source does not contain the expected data.
No such column [OTP OTD PS 2 (local copy)].[io:Top N reasons by site:nk].
any idea why? and what can I do to bring the sheets and dashboard back to life?
Hard to tell, looks like somewhere in between you've lost the calc field that you created. Could you explain what you did exactly?