Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Incremental Refresh and full refresh taking time

I have a power bi report with large dataset so an incremental refresh has been enabled.

 

Whenever I make any changes to the pbix and publish it starts a full refresh in the service which takes 45-50 mins.

 

Untill this refresh is in progress our users could not see old data as only last 1, month data is visible to them (configured in the schedule refresh)and they have to wait for 45 minutes everytime nee changes published.

 

 

How to fix this so that users should not wait for full refresh to complete or anyworkn around by that we can do full refresh in the backend once it's completed report can be linked to new data 

 

 

Please help

General Comment
Need Help
Tips and Tricks

2 Replies

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    2 years ago

    Hi Anonymous 

     

    This is because when you publish the PBIX it overwrites all of the data.

     

    If you are using Power BI Premium or Premium Per user you could use the ALM Toolkit to deploy just the changes which would keep the data?

     

    Another option is to make sure your PBIX has got all the historical data before you upload your changes. This will then have all the data while the incremental refresh starts in the background.

  • sergej_og's avatar
    sergej_og
    Icon for Super User rankSuper User
    2 years ago

    Hi Anonymous ,
    what kind of chnages do you proceed to Service?
    If you are on Premium capacity (XMLA endpoint) try to use third party tools to propagate your data model changes (new columns, relathionships, new tables) or measures.
    As GilbertQ mentioned ALM Toolkit is a nice one.
    I prefer to use Tabular Editor and/or ALM to make changes to model directly in/to Service.

     

    Regards