Forum Discussion

Redriver123's avatar
Redriver123
Frequent Visitor
1 year ago
Solved

Large Dataset - Refresh only YTD

Hello, I have created Dataflow A with historical data and disabled refresh, around 20 mil rows. Also created Dataflow B with YTD, Incremental refresh, takes about 2 minutes to refresh. In report, ...
Dataflow
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Redriver123 ,
    Thank you for reaching out to Microsoft Fabric Community Forum regarding the issue you are facing.

    Sorry for the delay in response. If the issue is still not resolved, Providing the workaround which might assist you in resolving the issue.
    1.Create a dataflow A for historical data and Dataflow B for YTD data. By separating historical and incremental data, avoid refreshing large volumes of unchanged data, saving time and resources.
    2.Then,in Power Bi Desktop load load historical and incremental dataflow into the Power Query Editor.
    3.Later create parameters for RangeStart and RangeEnd to define the incremental refresh range and close and apply the changes.
    4.Publish the report to power bi service and configure the incremental refresh for the dataset.

    Please feel free to contact us if you have any further questions. If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Redriver123 ,
I wanted to check in on your situation regarding the issue. Have you resolved it? If you have, please consider marking the reply that helped you as Accept as Solution or sharing your solution. It would be greatly appreciated by others in the community who may have the same question.

Thank you for being a valued member of the Microsoft Fabric Community Forum!