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 ...
Need Help
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