Forum Discussion

patilpoonam21's avatar
patilpoonam21
Helper I
2 years ago

Incremental refresh with condition

Hi,

 

The current refresh time for Power BI file is almost 50 mins. We need to apply incremental refresh with two conditions:

On weekdays, it should refresh current as well as previous month data and on weekend, it should refresh the entire dataset. We are using SQL server database. Is it possible to achieve this in Power BI desktop?

 

Thanks,

Rinku

 

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi, patilpoonam21

    1.First, you should arrange the time of schedule refresh reasonably, and arrange the schedule refresh at the time when the resource consumption is less.

    2.It is possible to achieve the advanced incremental refresh operation you describe in PowerBI with the help of XMLA endpoints, but there are some limitations and advice
    , if you really want to use incremental refresh and full refresh in turn, you must have a PPU license or above. You can refer to the following link for the specific configuration method:

    Advanced incremental refresh and real-time data with the XMLA endpoint in Power BI - Power BI | Microsoft Learn


    Best Regards,
    Yang
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous , amitchandak  Thank you co much for the reply.

    Is it possible to achieve that through Power BI M Query?

     

    Thanks,

    Rinku