Data Studio
4.8K members online now
4.8K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Problems Adding a Google Spreadsheet Data Source

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

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.

Problems Adding a Google Spreadsheet Data Source

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

I am having a similar problem creating a new data source with the Google Analytics connector.

Problems Adding a Google Spreadsheet Data Source

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

I am having a similar problem creating a new data source with the BigQuery connector.

Re: Problems Adding a Google Spreadsheet Data Source

Explorer ✭ ✭ ☆
# 4
Explorer ✭ ✭ ☆

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.