Forum Discussion
Data lake dataset refresh without authentication renewal
Sorry for my misunderstanding. Your Power bi account has enabled multi-factor authentication. But this is not for the Azure account you perform the schedule refresh. Right?
By default, the Refresh Token Max Inactive Time is 14 days. See: Configurable token lifetimes in Azure Active Directory (Public Preview)
You can use Multi-Factor for your Azure account. Or configure your current Azure account with maximum 90 days Refresh Token.
Regards,
I had been using my personal/administrative Azure Active Directory account credentials for the Power BI scheduled refreshes. That account had multi-factor authentication. I was experiencing the credentials expiring with that account.
I am now trying to use the credentials of a different user with more specialized permissions and Multi-Factory Authentication disabled. I'm hoping that this user's credentials won't expire, but I'm unclear if it will or not based on your post.
Is the refresh token a side effect of multi-factor authentication or do all OAuth credentials have this restriction?
I thought I had read somewhere that multi-factor authentication is what triggers the expiry, but it sounds now like I was wrong. Your link indicates that 'Multi-Factor Refresh Token Max Age' can be 'Until-revoked', and that single-factor and multi-factor can both be configured with the same expiry times. So that would seem to imply that multi-factor doesn't actually affect the credential expiry.
The refresh happens daily, so why would 'inactive time' apply? Wouldn't it be reset each time the refresh happens?
As you stated and as the link also states, the maximum inactive time is 90 days. If the daily refreshes do not reset the inactive time then I guess I must manually refresh credentials at least every 90 days. That's better than two weeks, but I would like to avoid the manual refresh altogether if possible.