Automatically refresh credentials for Azure Analysis Services on top Azure Data Lake storage RRS feed

  • Question

  • Hi,

    We currently have over 40 customers that we manage with each their own database and Analysis Services model that functions on top of Azure Data Lake storage. As the token for this expires monthly, we manually refresh the credentials as is more or less described at the end here: https://docs.microsoft.com/en-us/archive/blogs/analysisservices/using-azure-analysis-services-on-top-of-azure-data-lake-storage.

    This is costing us a lot of time every month, as we have to go through each client and click on them in Visual Studio.

    The same source says: "There is currently only one important caveat: The Azure Data Lake Store connector only supports interactive logons."

    That is why I was wondering if there are either:

    1. Workarounds for automation of the credential refreshment, that don't require years of Azure-engineering experience

    2. Any updates on supporting its automation from Microsoft in the near future

    Thanks a lot in advance.

    Rauf Akdemir

    Tuesday, September 22, 2020 6:16 PM