I have a power bi dashboard connecting to 20 google sheets which owned by different owners (around 10). I will have issue of token expired and scheduled refresh fail on and off.
May I know what is the main root cause and the solution to this issue. I suspect the google sheet owner update their organization credential/security and it cause the token expired. (my suspect might be wrong)
I would be appreciate it if you can help me out with this issue. Thanks