Refresh Azure Analysis services using rest api

Question

Refresh Azure Analysis services using rest api

sakuraime 2,341

I have a Azure analysis services , which has firewall enable

I would like to use ADF, through web activity , to refresh the model using AAS rest API https://learn.microsoft.com/en-us/azure/analysis-services/analysis-services-async-refresh

When AAS firewall enable , do I still need install a self-host IR VM to do the refresh ?
CAn use data factory MSI ?
Are there incremental refresh ?
And how to mention what credential in the model to get data from Azure sql database ?

1 answer

Your answer

Answer 1

Nandan Hegde 36,146 MVP Volunteer Moderator

Hey,
I am going with the assumption that you would be triggering the refresh of AAS via ADF , below are the answers to your queries:

1) When AAS firewall enable , do I still need install a self-host IR VM to do the refresh ?
Ans: Every ADF region has some specific IP ranges which are published by MSFT, you would need to whitelist those IP ranges in the firewall

2) Can use data factory MSI ?
Ans: techtalkcorner.com/azure-data-factory-refresh-analysis-services/

3) Are there incremental refresh ?

Ans: Based on my understanding , its not possible and you would need to do partitions for partial tables processing if need be
https://learn.microsoft.com/en-us/answers/questions/251394/how-to-incrementally-refresh-azure-analysis-servic.html
https://stackoverflow.com/questions/60078345/azure-analysis-services-incremental-refresh

4) And how to mention what credential in the model to get data from Azure sql database ?
Ans: That is a part of AAS deployment. You can access the Azure SQL DB from AAS via SQL auth creds

sakuraime 2,341 Reputation points

2022-02-16T17:17:33.71+00:00

thanks for your response .

ican specific which IP range ? the ADF is at eastasia .. the IP is very long

And I have another question is the model is loading data from Azure sql database. what's the network requirement to load data to AAS from Azure sql databaes .? Azure sql databases don't allow 'Azure services'
at firewall.

in this case , need a ' on-prem data gateway' for AAS ??

4) And how to mention what credential in the model to get data from Azure sql database ?
Ans: That is a part of AAS deployment. You can access the Azure SQL DB from AAS via SQL auth creds <<< Only SQL AUTH ?
sakuraime 2,341 Reputation points

2022-02-17T17:11:03.407+00:00

any idea ?
Nandan Hegde 36,146 Reputation points MVP Volunteer Moderator

2022-02-18T03:49:37.533+00:00

Hey,
Sorry for missing out on this thread!
!
w.r.t IPs:
https://learn.microsoft.com/en-us/azure/virtual-network/service-tags-overview#discover-service-tags-by-using-downloadable-json-files

Yes, there can be multiple IP ranges which we would need to whitelist.

And w.r.t refreshing cube, yes ; you are right that we would need a gateway and the server on which the gateway is installed should be able to access both Azure SQL database and AAS (meaning we would need to whitelist the server IPs in both Azure SQL Db firewall and AAS firewall.
Nandan Hegde 36,146 Reputation points MVP Volunteer Moderator

2022-02-21T16:37:06.793+00:00

Hey, Did it answer your query ?
Please accept it answer in case if helped you with the query as it may benefit other community members as well

Share via

Refresh Azure Analysis services using rest api

1 answer

Your answer