Fay Wong on 24 Feb 2021 17:31:16
We are implementing the Filtered Agg technique in our enterprise certified dataset. Because of that we have to turn on Dual mode for all the related dimension tables. We have a very challenging dataset to work with as our dimensions are very large - vendor, item listing by location, members, and etc.
Since these dimensions are slowly changing, we really don't want them to be fully refreshed every day. I have tested the full refresh of a "mid-sized" table and it's 1 full hour to refresh in PBI Gen2.
We'd love to be able to do incremental refresh of dual tables to give us more control and reduce the waste of refreshing the entire dimension every day.