question

RamakrishnaMandalapu-6041 avatar image
0 Votes"
RamakrishnaMandalapu-6041 asked RamakrishnaMandalapu-6041 commented

How to refresh on prem cube using ADF

In on-premise I have a cube(server version 20174).I need to refresh cube from ADF.Is there any solution for it.

azure-data-factoryazure-synapse-analyticssql-server-analysis-servicesazure-analysis-servicesazure-stack-hub
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @RamakrishnaMandalapu-6041, thank you for your post. It seems that there is no direct connector to on-premise SSAS in ADF. But you coulde refer to below links that provided by NandanHegde-7720.

0 Votes 0 ·

Please Provide link

0 Votes 0 ·

  • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how

0 Votes 0 ·
VaibhavChaudhari avatar image
0 Votes"
VaibhavChaudhari answered

There are 2 suggestions given in below similar thread i.e. running T-SQL to refresh the Cube and another is calling Azure Function:

https://docs.microsoft.com/en-us/answers/questions/212042/process-a-ssas-via-azure-data-factory.html


Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

NandanHegde-7720 avatar image
0 Votes"
NandanHegde-7720 answered

Hey,
The below blog provides step by step solution for the same:


https://datasharkx.wordpress.com/2021/03/15/refresh-ssas-tabular-model-from-azure-data-factory/

An extension over what was recommended by Vaibhav.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.