Data Studio not seeing worksheets in GoogleSheets[ Edited ]
May 2017 - last edited May 2017
A report we are using via Data Studio has completely broken this last week and I've been unable to resolve. I assumed since all fields broke it was an issue connecting to the data source (which is a Google Spreadsheet). When I went to edit the connection, when selecting the spreadsheet, it says that "There are no worksheets available in this spreadsheet." when in fact there are multiple.
What may have happened to cause Data Studio to not see the worksheets in the spreadsheet?
Re: Data Studio not seeing worksheets in GoogleSheets
Data Studio not seeing worksheets in GoogleSheets
- A Google Sheet connects fine with all its worksheets.
- I make a copy of the Sheet and modify a few calculations inside
When I try to add a data source the COPY of the connected sheet, then none of its worksheets are shown.
What's the solution?