Forum Discussion
OAuth2 Authentication credentials
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
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-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.
2 Replies
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-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.