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://video2.skills-academy.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.
447 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. HimanshuSinha-msft 19,471 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
  2. Nandan Hegde 31,871 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

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.