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

Data Studio and Google Spreadsheet: Data Sources not attached to the report

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

There is a Google spreadsheet which is refreshed every day in an automated manner - data is taken from DB and Node.js 'googleapis' package writes new data every night to the same file.

You can always open this file with the link like docs.google.com/spreadsheets/d/abcdefg_a_really_long_URL_12345. But when I add this file as a data source to google Data Studio - it works only untill the file is refreshed. After that I'm getting an error: "One or more of the Data Sources used in this Report is not attached to the report.", while the file still can be opened with the same link.

If I press the "RESOLVE" button I'm seeing

Data source: 

Name: (Unknown), Status: yellow triangle /!\ "Problems with the connection" REQUEST ACCESS, Actions: Edit (inactive), REMOVE.

If I press "REQUEST ACCESS" - I'm getting the "Not Found Error 404" message. While the file still can be opened with it's link.

What's happening and why?

1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by topic author Vladimir P
July

Data Studio and Google Spreadsheet: Data Sources not attached to the report

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

Not actual any more. 

Been using drive.files.update, now sheets.spreadsheets.values.update

This solved the problem

View solution in original post

Data Studio and Google Spreadsheet: Data Sources not attached to the report

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

Someone knows what's happening? Anyone?

Marked as Best Answer.
Solution
Accepted by topic author Vladimir P
July

Data Studio and Google Spreadsheet: Data Sources not attached to the report

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

Not actual any more. 

Been using drive.files.update, now sheets.spreadsheets.values.update

This solved the problem