Forum Discussion
Setting up incremental refresh for a dimension table
How does Power BI by the way know what makes a row in a query unique?Power BI doesn't know that, and doesn't care. It will aggregate as much as it can. It is your job to prevent the aggregation by adding the unique columns to the visual and/or filter context.
Q1: If your Creation Date for the dimension items is immutable then an incremental refresh is possible.
Q2-Q4: not clear what you are asking.
Q5: Ideally you should have different Creation Date columns for your facts and your dimensions.
How does Power BI by the way know what makes a row in a query unique? Power BI doesn't know that, and doesn't care. It will aggregate as much as it can. It is your job to prevent the aggregation by adding the unique columns to the visual and/or filter context.
Q1: If your Creation Date for the dimension items is immutable then an incremental refresh is possible.
Q2-Q4: not clear what you are asking.
Q5: Ideally you should have different Creation Date columns for your facts and your dimensions.