AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

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

Data Connection

[ Edited ]
Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

When I select my data source from Google Sheets, it does not give me the option of connecting or adding to the report.

1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by topic author Shatiek G
May 2017

Data Connection

Participant ✭ ☆ ☆
# 4
Participant ✭ ☆ ☆

My assumption is something with permissions and/or access.  May try duplicating the the GDrive document, removing others permissions, etc.  But primarily seen this when some type of permission issue occurs.

 

Also could occur if the Gdrive document was moved into new folder or something similar and breaks the access.

View solution in original post

Data Connection

Participant ✭ ☆ ☆
# 2
Participant ✭ ☆ ☆

What're your permissions with the Google Sheet?  Are you the Owner? Viewer? Editor? etc

Data Connection

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

I am the owner of the sheet, but it is on a Team Drive. Could that be the issue?

Marked as Best Answer.
Solution
Accepted by topic author Shatiek G
May 2017

Data Connection

Participant ✭ ☆ ☆
# 4
Participant ✭ ☆ ☆

My assumption is something with permissions and/or access.  May try duplicating the the GDrive document, removing others permissions, etc.  But primarily seen this when some type of permission issue occurs.

 

Also could occur if the Gdrive document was moved into new folder or something similar and breaks the access.

Data Connection

Visitor ✭ ✭ ✭
# 5
Visitor ✭ ✭ ✭

Okay, thank you! I think you are right! Thank you for this.