Share via

How many ways we can refresh cube

Ramakrishna Mandalapu 21 Reputation points
2022-02-19T14:27:37.03+00:00

I have one Cube in on Prem how many ways we can refresh by using on Prem and Azure .

Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
2,162 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,568 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,276 questions
Windows Server PowerShell
Windows Server PowerShell
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.PowerShell: A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
5,509 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Nandan Hegde 32,026 Reputation points MVP
    2022-02-19T16:45:04.153+00:00

    Hey,
    There are multiple ways:

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

    2) create a sql job within server and execute the stored procedure to refresh the ssas

    3) you can use powershell to refresh ssas as well.
    You can leverage sql server job for that as well

    0 comments
  2. CarrinWu-MSFT 6,871 Reputation points
    2022-02-21T06:24:38.09+00:00

    Hi @Ramakrishna Mandalapu ,

    Thank you for your post.

    In on-premises SSAS, you could manually process cubes in SSMS. Or using SSIS packages to process cubes. For more information, please refer to How to Automate SSAS Tabular Model Processing.

    Best regards,
    Carrin

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    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.