Data Studio and Google Spreadsheet: Data Sources not attached to the report
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
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?