Forum Discussion
Distinct Lists from Incrementally Refreshed Table
Hi BenjaminC
Do you use the license premium and use the feature incremental refresh?
Or do you use some workaround with pro license?
Besides, there are some workarounds with a pro license.
https://www.youtube.com/watch?v=u7SyqTpLIJc
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi v-juanli-msft,
Thank you for your reply. Yes, I do have access to a premium workspace, where I do the incremental refresh. So no, I'm not using any workarounds.
My issue is also not with the incremental refresh. That refreshes the fact table the way I want it to.
My issue is with the dimension tables I create that reference the incrementally refreshed fact table. They are subsets of the actual dimension tables, that I create by referencing the incrementally refreshed fact table key column(s) in a List.Distinct expression. I then merge that distinct list of keys back to the dimension table.
My expectation was that Power Query would overwrite the parameters to do the incremental refresh, create the list of unique keys within those overwritten parameters, and merge that back to the dimension table. But after publishing to the service, I notice that it's only actually creating a subset using my original parameters (that I defined in Power BI desktop). So it either keeps using those pre-defined parameters for some reason, or it's not refreshing at all.
I thought it might have something to do with the parallel loading of queries, but turning that off doesn't change anything.
I hope that makes sense...
Benjamin