Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

AAS Cube refresh

Hi All,

 

I have one basic question:

 

During AAS tabular cube refresh (with Type:Full) will there be no data available for consuming Power BI Reports.

How does AAS cube refresh work. Is it like truncate and reload?

Will end user will be able to view data in PBI report at the time of full Cube refresh?

 

 Currently i'm refreshing my cube(s) are getting refreshed through ADF Pipeline using API calls. Below is the command

 

{"Type":"Full","CommitMode":"transactional","MaxParallelism":2,"RetryCount":2}

 

Please let me know .

Let e

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Please provide some input to above query.

     

  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    5 years ago

    Hi Anonymous 

     

    Sorry for the late reply. For your question, end users will be able to view data in PBI report at the time of full Cube refresh.

     

    In Power BI Service, operations are classified as either interactive or background. Interactive operations include rendering requests and responding to user interactions (filtering, Q&A querying, etc.). Background operations include dataflow and import model refreshes, and dashboard query caching. Interactive operations are always prioritized over background operations to ensure the best possible user experience. If there are insufficient resources, background operations are added to a waiting queue until resources free up. Background operations, like dataset refreshes, can be interrupted mid-process by the Power BI service, added to a queue, and retried later on.

     

    Refreshes of import models are always memory intensive as models must be loaded into memory. Additional intermediate memory is also required for processing. A full refresh can use approximately double the amount of memory required by the model because Power BI maintains an existing snapshot of the model in memory until the processing operation is completed. This allows the model to be queried even when it's being processed. Queries can be sent to the existing snapshot of the model until the refresh has completed and the new model data is available.

     

    If you have interest, here is a detailed document about how it works.

    https://docs.microsoft.com/en-us/power-bi/admin/service-premium-what-is#how-capacities-function

     

     

    Best Regards,
    Community Support Team _ Jing Zhang
    If this post helps, please consider Accept it as the solution to help other members find it.