Forum Discussion
Table Relationships in Incremental refresh only created for Active Partitions
I have a Power BI dashboard which uses incremental refresh for TableA with the incremental setting set to 3 months of data and 5 years of archive data. I have a small TableB which does not use incremental refresh. These two tables have a relationship. The problem is that the relationship seems to only work for the incremental partitions and not the archived partitions. That is, if I have a table visualization with fields from both tables, I only see 3 months of data. Likewise, if I have a visualization with fields only from TableA, but have a filter using a field from TableB, then I only see 3 months of data. How do I get the relationship to work with the archived 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
7 Replies
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.
If you work on Power BI Desktop this might happen because of the incremental refresh(RangeStart / RangeEnd), otherwise in service this can not happen if you have successfully refreshed the model and relations works properly in your model.
This does happen in the service.
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
