Forum Discussion

robotbi's avatar
robotbi
Frequent Visitor
2 years ago
Solved

Incremental refresh on Report with auto refresh Dataflow

Hi, this may be a silly question.. I need to build a Bi report which shows cost trends from 2019 to yesterday, and table contains 300million rows, so I have to set up incremental refresh. On Po...
dataflow
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi robotbi ,

    Below is my table:

    Now you should create two parameters: RangeStart and RangeEnd

    Here's a detailed incremental refresh strategy based on your rules:

    After that, you can publish it to the service, and then you can set up a scheduled refresh every morning at 6:00 am to refresh.

    Static data for 2019-2023 will remain unchanged, while data for 2014 will be progressively refreshed based on date parameters you define.

    Best Regards,

    Xianda Tang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi robotbi ,

Below is my table:

Now you should create two parameters: RangeStart and RangeEnd

Here's a detailed incremental refresh strategy based on your rules:

After that, you can publish it to the service, and then you can set up a scheduled refresh every morning at 6:00 am to refresh.

Static data for 2019-2023 will remain unchanged, while data for 2014 will be progressively refreshed based on date parameters you define.

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.