question

RRNetha avatar image
0 Votes"
RRNetha asked KranthiPakala-MSFT commented

Azure Analysis Services OAUTH token expiry

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
image.png (119.1 KiB)
· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

HI @RRNetha,

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

0 Votes 0 ·

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

0 Votes 0 ·

HI @RRNetha,

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.

0 Votes 0 ·
RRNetha avatar image RRNetha KranthiPakala-MSFT ·

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

0 Votes 0 ·

1 Answer

KranthiPakala-MSFT avatar image
1 Vote"
KranthiPakala-MSFT answered KranthiPakala-MSFT commented

Hi @RRNetha,

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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.

0 Votes 0 ·