How to refresh on prem cube using ADF

Ramakrishna Mandalapu 21 Reputation points
2022-02-07T07:42:14.697+00:00

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

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
439 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,454 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,714 questions
Azure Stack Hub
Azure Stack Hub
An extension of Azure for running apps in an on-premises environment and delivering Azure services in a datacenter.
180 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,249 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Vaibhav Chaudhari 38,641 Reputation points
    2022-02-07T08:02:20.06+00:00

    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://learn.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

    0 comments No comments

  2. Nandan Hegde 29,901 Reputation points MVP
    2022-02-08T03:28:33.423+00:00

    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.

    0 comments No comments