Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
What is recommendation for handling scheduled refreshes on Datasets/Dataflows when you are using OAuth2 credentials to connect to a datasource?
It seems that once the access token expires, then the scheduled refresh will no longer work - and there is no way to provide a refresh token as part of the credentials.
We can work around this for some datasources by using non-expiring credentials (e.g. basic auth). But for some datasources (e.g. Dataflow), OAuth2 is the only option.
We are considering creating our own service for updating credentials and triggering the refreshes, unless there is something available in the platform we are missing?
We use a 'service' account that has credentials that don't expire.
I'm not sure I understand? We also use 'service account' users to get around expiring passwords, but for the datasource credentials you have to provide an access token (not the username/password basic creds) which does expire.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.