OAuth2 Authentication credentials

Hi Anonymous ,

Thanks for 3CloudThomas's reply!
And Anonymous , Based on the screenshot you provided, it seems that you are using Dataflows Gen1. Dataflows Gen1 is about to be deprecated, and when using OAuth2 credentials in Dataflows Gen1, the gateway does not support automatic refresh of tokens when the access token expires.

https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-tshoot#limitations-and-considerations 

https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-onprem-faq#why-do-i-get-the-errors--invalidconnectioncredentials--or--accessunauthorized--when-accessing-data-sources-using-oauth2-credentials-from-dataflows-gen1-even-though-the-credentials-are-updated-recently--mid-stream-token-refresh-issue-- 

You can refer to the user's answer in this thread:
Re: Oauth2 gateway bugs affecting datasets not dat... - Microsoft Fabric Community

If you don't want to manually update the credentials every time, the best thing to do is to change your dataflow from Gen1 to Gen2.

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.