Forum Discussion
Setting up incremental refresh for a dimension table
Hi, my experience with incremental refresh is just daily updating transactions. Most of the time that is just adding transactions to a fact table in the Power BI semantic model. Dimensions are fu...
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.
lbendlin thnx for you answer. I dived a little more in it, things are more clear now.