Google sheets credentials in Gateway break too often

[Mare_Ruiz]

Hi community!

I've been having an issue where my reports in the Power BI Service can't update because of broken credentials on the Google Sheets I have in the gateways. 

I fix them almost daily now and it's too much work. 

Does anyone knows how to increase the time it takes them to break?

[collinq]

HI @Mare_Ruiz ,

Are you using the google connector?  Power Query Google Sheets connector - Power Query | Microsoft Learn

Or, maybe with these instructions you can publish them as a web page?  Connect Google Sheets to Power BI: An Easy Guide (hevodata.com)