BigQuery - Oath able to login to Data source, but next day fails test connection

[mduo74]

Hello,

I have PBI semantic model in Fabric connected to just BigQuery. I do connect using Oath2 Data source credentials and am able to use the model. However the next day when I try to use something with the model the data fails to load -> In semantic model Data source credentals there is error "Failed to test the connection to your data source. Please retry your credentials."

All I do is click Edit credentials and click Sign in, no changes to the credentials but I have to do it manually every day. How to fix this so it wont be disconnecting from model.
Thanks

[Anonymous · Accepted solution]

Hi, @mduo74 

Please check the token expiration settings, and verify that your BigQuery project has an expiration policy specifically for OAuth2 tokens.
azure data factory - How to avoid BigQuery refresh token expiry - Stack Overflow

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum