Forum Discussion
Helper VDiffering rows between the online Dataflow and Desktop Power Query Editor
I ended up raising a ticket with Microsoft for this and in summary, they think something went wrong with the dataflow merge and the resolution was to recreate it, as when exported to JSON, it was fine.
Super UserDayna make sure when you configured the incremental refresh your filter on rangestart and rangeend are not overlapping. This is the common issue I have seen, check filter data section at this post Configure incremental refresh and real-time data for Power BI datasets - Power BI | Microsoft Docs
✨ Follow us on LinkedIn
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Helper VHello,
I did this originally, then I saw somewhere on the forums that as PowerBI Premium capacity, I could do this in the dataflow. I simply had to go into the dataflow and on the table, select 'Incremental Refresh', all my date/time fields were available in the dropdown so I set the period to retain and the period to refresh.
If I've done it this way, do I still need to apply a filter?
So what I've done to most is set this to retain the last 5 years of data, but refresh the last 3 months.
Many thanks,
Dayna