Error on connecting data source every day
Im having issue about data source connection. Everyday I have to reconnect the data source (Google Sheets) for my dashboard in data studio.
The charts are replaced by connection error report in the dashboard.
This error is fixed when i hit fix it button on the data studio.
I have already allowed data studio permission once. But everyday giving permission is really painful.
How to fix it with out accessing and giving permission each day to google data studio ?