Azure Analysis Services OAUTH token expiry

rajendar erabathini 616

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

KranthiPakala-MSFT 46,437 Reputation points Microsoft Employee

2021-07-16T18:51:14.023+00:00

HI @rajendar erabathini ,

Thanks for using Microsoft Q&A forum and posting your query.

This is an AAD level setting that has to do with user credentials expiring. For AAS, please have a look at using the asynchronous refresh feature here to allow for long running processing:

https://azure.microsoft.com/blog/asynchronous-refresh-with-the-rest-api-for-azure-analysis-services/

Please check this article and let us know if it helpful for your use case. Do let us know how it goes.

Thanks
rajendar erabathini 616 Reputation points

2021-07-17T16:18:28.57+00:00

Thanks @KranthiPakala-MSFT ! I am not sue whether I have articulated my issue clearly. My issue here is in the "Credentials" section in above screenshot i am giving my Azure credentials and it authenticates successfully, however when i try to process the cube next day its fails becuase "OAUTH2" authentication expires. Why i have to authenticated myself everyday to connect datasource. Is there any other way to authenticate the datasource.

thanks
KranthiPakala-MSFT 46,437 Reputation points Microsoft Employee

2021-07-21T20:45:32.983+00:00

HI @rajendar erabathini ,

Thanks for you response and clarifying the ask.
As you are trying to refresh the token in SSMS, I'm not sure if this is possible in SSMS, but let me reach out to internal team to see if there are any other ways to achieve it. Will get back to you as soon as I have update from the team.

Thank you for your patience.
rajendar erabathini 616 Reputation points

2021-07-23T06:52:57.477+00:00

Thanks @KranthiPakala-MSFT ! Also i wanted to now when we move the Cube to prod how can we overcome this issue. Per say if i am using Azure Automation which credentials i need to use to connect the datasource without expiring the OAUTH token.

thanks

Accepted answer

KranthiPakala-MSFT 46,437 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:

Refresh with Azure Automation

Refresh with Logic Apps

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.
Please sign in to rate this answer.

1 person found this answer helpful.
KranthiPakala-MSFT 46,437 Reputation points Microsoft Employee

2021-08-04T06:22:08.78+00:00

Hi there,

Just checking in to see if the above suggestion was helpful. If it answers your query, please do click “Accept Answer” and/or Up-Vote, as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

Rogier Wijsman 0 Reputation points

2024-04-25T15:28:49.1233333+00:00

This does not seems a correct answer? It addresses a different question. Not the question of the topic.
Sign in to comment

Share via

Azure Analysis Services OAUTH token expiry

0 additional answers