The Data Source is Google Sheets. I am the owner of the Looker Studio report. I am the Editor of the Google Sheets.
When I set the Looker Studio Google Sheets Data Source Data Credentials to Owner’s Credentials - Make me the Owner, it breaks the charts. But when I set it to Viewer’s Credentials, I can see the charts. Since I’m the one currently viewing, this proves that I have the right to see the charts.
Changing to Owner’s Credentials -Make me the Owner shouldn’t break the charts. I should be able to see the charts if I set it to Owner’s Credentials because I am an editor of the Google Sheets.
Why is this so? Can anybody from the Google Team look into this please? Thank you.