OAuth2 Authentication credentials

[Anonymous]

Hi Team,
In Power BI report, I was connecting the Dataflow as a data source.

I am using OAuth2 as the authentication method to connect to the Dataflow for scheduled refresh. However, the connection expires after 24 hours, and I have to re-enter the credentials again every day to make the connection successful.
How can I resolve this issue and automate the scheduled refresh without needing to manually re-enter the credentials every day?

Thanks,
w_Das

[Anonymous · Accepted solution]

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.

[Anonymous]

execute the dataflow 2-3 times a day and see if the authentication sticks. Not running for 24 hours expires the token in your case.