Forum Discussion
Table Relationships in Incremental refresh only created for Active Partitions
Hi RThompson777 ,
Thanks for reaching out to the Microsoft fabric community forum.
Incremental refresh does not build or apply relationships separately for active and archived partitions. Relationships are defined at the model level and apply to all partitions once the dataset is successfully refreshed in the Power BI Service. There is no difference in how relationships work for incremental versus archived data.
If archived data only disappears when using fields or filters from TableB, this usually points to a data or filtering issue rather than incremental refresh behavior. Common causes include key mismatches in historical data, data type or formatting differences, or filters propagating from TableB (such as bi-directional relationships or RLS).
If I misunderstand your needs or you still have problems on it, please feel free to let us know.
Best Regards,
Community Support Team
RThompson777 Have a look at this article and see if it helps:
Power BI Incremental Refresh: Archiving Data from a Fixed Date | by Adolfo J Socorro | Medium
Is it possible that something is different in the archive data that doesn't quite match what is in Table B?
That article describes how incremental refreshes work. But it does not mention how Relationships are built during incremental refreshes. In particular, I'm interested in how the relationships between a non-incremental table and an incremental table are created during an incremental refresh, and if there is a difference in the process for active vs archived partitions.