Forum Discussion
MarkBurgess
Advocate I
Advocate IDataflow Gen2 lakehouse connection token expired
Hi, I have a Dataflow Gen2 that updates a Lakehouse table from an on-prem SQL database. There is a shared connection set up to the destination Lakehouse, but the only option for authentication is OAu...
Akash_Varuna
Super User
Super UserHi MarkBurgess , could you try these
- Use Azure AD App Registration: Create an app registration in Azure AD, grant permissions, and use the app's credentials for authentication.
- Service Principal: Switch to service principal authentication for long-term access.
- Automate Renewal: Use a script or tool to refresh the token periodically.
If this post helped please do give a kudos and accept this as a solution
Thanks In Advance
MarkBurgessAdvocate I
Advocate IHi Akash_Varuna , thanks for the reply. OAuth2 is the only option for Lakehouse connections, so I'm not sure I can do either of the first two options
How would I go about the third option, would that not still involve refreshing the shared connection with the new token?
Thanks
Did you ever find a solution? I'm also stuck on this
- MarkBurgess
Hi, TheDataGirl , no I'm afraid not. The solution for me was to stop using Data flows in production. I haven't checked recently to see if any other authentication methods have been added.
