Share via

Auto Refresh Tabular Model

Swapnil 216 Reputation points
2021-02-01T22:16:35.507+00:00

Hi All,
I need to have my SSAS Tabular Model auto refreshed every day at certain time so that newly added data in tables are pulled in model and subsequently in Power BI reports.

Can anyone guide me to have steps to do the needful?

Thanks

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,253 questions
Accepted answer
  1. Lukas Yu -MSFT 5,816 Reputation points
    2021-02-04T02:11:19.163+00:00

    Hi,

    I convert your comment to the question comment as a description, hope you don't mind.

    To auto process Azure Analysis Service database, is somewhat different with On-Prem SSAS.

    There are various ways to do this task.

    One I know is claimed to be the simplest way to do this is to use Azure Automation service. It is not so simple that can be describe with couple screenshot , you could read and follow Chris Walden's great blog : How to Automate Processing your Azure Analysis Services Models

    Another way is to use Azure Function, I also put it here you might be interested : HOW TO AUTOMATE PROCESSING OF AZURE ANALYSIS SERVICES MODELS

    Hope this is useful.

    Regards,
    Lukas

    If the answer is helpful, please click "Accept Answer" and upvote it.

    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.
    What can I do if my transaction log is full?--- Hot issues November
    How to convert Profiler trace into a SQL Server table -- Hot issues November

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Nandan Hegde 29,916 Reputation points MVP
    2021-02-02T03:10:45.703+00:00

    Hey @Swapnil
    There are multiple ways to automate the processing of SSAS via SSIS packages, SQL jobs etc.

    Please refer the below link for complete details:
    https://www.biinsight.com/how-to-automate-ssas-tabular-model-processing/

    As for PowerBI, you can set scheduled refresh via app.powerbi.com for datasets

    1 person found this answer helpful.
    0 comments
  2. Lukas Yu -MSFT 5,816 Reputation points
    2021-02-02T03:22:24.497+00:00

    Hi,

    Generally there are two ways we recommend:

    1. Use SSMS SQL Agent to schedual a job that process the Tabular model.
    2. Or, you could create a SSIS package to process the SSAS database (if you have a SSIS server installed.)

    I would recommend the first approach, as it is quite simple that doesnot required a SSIS server.

    Regards,
    Lukas