Problems Adding a Google Spreadsheet Data Source
I have been adding several Google Spreadsheets to a report in Google Data Studio. When I tried to add my most recent data source, the "connect" button goes missing as soon as I enter a specific worksheet's fields. I'm therefore unable to move forward with connecting the data source to my report. I have tried logging out and logging back in as well as restarting my browser and computer with no luck.
Re: Problems Adding a Google Spreadsheet Data Source
Well, i tried and i saw where is your problem.
To solve it, follow those steps.
In your report in Data Studio, add a new page.
1 - click right on the page content and "select settings for this page"
2 - Select "Data" and click on the arrow after the text "Data source", it will display your "added data source" and "available data source" by type
3 - click at the bottom, on the button "create a new data source"
If it's the first time that you add a new data source in your report Data studio, you need to answer 4 askings in the form.
4 - After this, you can select your connectors data source, elements, spreadsheets...
5 - Click on "associate"
6 - Click on "Add to the report".
I hope it will help you all.