SQL Auth for AAS

Question

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

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

Answer 1

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

Answer 2

Hey Sahil,

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