Forum Discussion
SeattlePowerBI
6 years agoHelper III
SSAS Tabular 2017 Oauth2 Credential Refresh
I have an SSAS 2017 Tabular model hosted on prem. It is pulling data from the Dynamics 365 OData feed and using OAuth2. The problem i am having is that one authenticated, OAuth2 issues an access token and it expires after an hour. So, I'm able to automate processing of hte model using SQL Agent for 1 hour, and then everything fails. Can anyone help with how to automate the refresh of credentials or whether that is possible with SSAS 2017 on prem?
No RepliesBe the first to reply