SQL Auth for AAS

Sahil Mehta 61 Reputation points
2022-04-14T12:23:12.71+00:00

We have an azure analysis service with firewall enabled. So to refresh a powerbi report, accessing AAS I need a gateway.

193080-image.png

We have MFA enabled on our accounts so we are unable to set up the gateway. So is there are any other way like SQL accounts used in Azure SQL DB, for accessing AAS?
This is similar to my previous thread for which I didn't receive any correct response :
https://learn.microsoft.com/en-us/answers/questions/623102/copy-data-from-aas-via-adf.html

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

2 answers

Sort by: Most helpful
  1. HimanshuSinha-msft 19,386 Reputation points Microsoft Employee
    2022-04-18T19:58:38.277+00:00

    Hello @Sahil Mehta ,
    Thanks for the question and using MS Q&A platform.
    As we understand the ask here is how to refresh AAS with the firewall set ., please do let us know if its not accurate.
    You are correct AAS is very tightly coupled with the AAD and at this time you do not have anything like SQL accounts .
    The firwall which is set on the AAS does that allow you to other Azure service to interacts with AAS ? One way which you can try is to user ADF . The below link which calls out the steps in great detail .
    https://www.techtalkcorner.com/azure-data-factory-refresh-analysis-services/
    Please do let me how it goes .

    Thanks
    Himanshu

    0 comments No comments

  2. Nandan Hegde 31,436 Reputation points MVP
    2023-05-19T05:16:06.9133333+00:00

    Hey Sahil,

    As stated above and confirmed by MSFT via a diff ticket, it is not possible

    User's image

    User's image

    0 comments No comments