Forum Discussion

RThompson777's avatar
RThompson777
Frequent Visitor
6 months ago
Solved

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 increm...
Need Help
  • v-menakakota's avatar
    v-menakakota
    6 months ago

    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

cengizhanarslan's avatar
cengizhanarslan
Super User
6 months ago

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.

RThompson777's avatar
RThompson777
Frequent Visitor
6 months ago

This does happen in the service.

  • v-menakakota's avatar
    v-menakakota
    Community Support
    6 months ago

    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

    • v-menakakota's avatar
      v-menakakota
      Community Support
      6 months ago

      Hi RThompson777 ,

      I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you .

       

      Best Regards, 
      Community Support Team

       

      • v-menakakota's avatar
        v-menakakota
        Community Support
        6 months ago

        Hi @RThompson777 ,

        I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you .

         

        Best Regards, 
        Community Support Team