Forum Discussion
Solved
Incremental refresh and dimension table surrogate keys
Hello, I need to know if the Power BI dataflow incremental refresh feature is able to help with this scenario. I am building a star schema with a dimension table called Client. The Client table gr...
Hi emsrc
The Power BI Incremental refresh can only be used on a column with Date/Time format. What you could do is to have an insert date on your dimension table.
Then use this Insert date to incrementally process the latest N days. And still use the surrogate key on your dimension to fact table relationships?
GilbertQ
Super User
Super UserYeah that is what I thought hopefully that will help you.