Forum Discussion
Month-end Dataflow Refresh Process
There's no way to do what you're wanting while keeping the existing IR policy.
Once the accounting period closes, I'm assuming those "closed" records no longer change.
I would look at splitting the Dataflow into two, one for closed and one for current. You can then have separate IR policies on each and just combine the Dataflows in your model.
Hi Anonymous ,
Based on your description, you can try the following to toggle the refresh range. First, you can introduce a parameter in the data stream that allows you to toggle between an incremental refresh and a full refresh for the previous month. Use conditional logic in the data stream to check the value of the parameter. If it is set to “End of month”, adjust the refresh logic to process only the previous month's data. Or you can create a dynamic date filter in Power Query that adjusts to the current date. For month-end processing, set the filter to include only the previous month's data.
Best regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly