Unable to Connect Google Sheets as a Data Source in Looker Studio

Our company has been having an issue for over a month in which no one is able to add any Google Sheets as a data source in Looker Studio.

Initially we couldn't even see our sheets, however, we've since found that setting a filter does get our sheets to display and be selectable, but then we are never given the option to select a Worksheet and therefore cannot complete the Connect/Add function.

I can share screenshots or link a video of the fault if that would be of any help.

Any help would be greatly appreciated as this matter has become urgent for us.

Many thanks,

Stefan

0 5 1,710