Forum Discussion
Dataflow stopped saving historical data
Hi sangeetaraman ,
Are the settings now the same as when it worked before? Have any changes been made?
When you need Historical Data Preservation using Power BI Dataflow, Create two entities, one for storing transactional data and another for storing historical data.
Entity for transactional data:
Always stores data for the current year. Once the entity is created, schedule it daily as needed, so as to initiate the incremental refresh.
Entity for historical data:
Only stores the historical data for the previous year and older. This entity can be scheduled if needed or can be triggered manually once a year as needed.
You can reference the following document which may be helpful to you.
Historical Data Preservation using Power BI Dataflow - Visual BI Solutions
Best Regards,
Community Support Team _ xiaosun
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello v-xiaosun-msft ,
Thanks for your response. There was a change introduced in the source- Two new columns were inserted into the same query. I also see another error which was not the case earlier, "Unable to confirm if M Query can be folded"-screenshot below. Can you please guide me how to rectify this?
Thanks
Sangeeta