Azure Analysis Services OAUTH token expiry

rajendar erabathini 616 Reputation points
2021-07-15T10:16:11.16+00:00

Hi - Is there any way we can avoid expiring the OAUTH token to connect the data source when processing the tabular cube from SSMS. I believe it expires after 2 hours every time. our team need to refresh the credentials to get that processed every time. Please suggest any workaround. thanks

115071-image.png

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
456 questions
{count} vote

Accepted answer
  1. KranthiPakala-MSFT 46,502 Reputation points Microsoft Employee
    2021-08-02T20:59:15.503+00:00

    Hi @rajendar erabathini ,

    Apologies for the delay in response. I did confirmed with internal team that auto refresh of token is not possible from SSMS. You can perform automated data refresh operations on your Azure Analysis tabular models by following any of the below automated approaches:

    1. Refresh with Azure Automation
    2. Refresh with Logic Apps
    3. Asynchronous refresh with the REST API

    Here is an article from a community expert on how to use Azure Logic App to automate Azure Analysis Services model refresh tasks: Overview of Azure Analysis Services and Logic App Tasks

    Hope this info helps.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.