Forum Discussion
DimTables refreshing unreal data
Hello Community,
After modifying my Fact table and i hit close and apply, the fact just loaded all its data but the Dim table that was affected by that change is loading unreal data, as you can see in the attached snip it's getting up to 12+M rows yet it only has 46 rows. I'd like to understand what causes this behavior.
1 Reply
- d_m_LNK
Super User
I don't know any details about your environment but this behavior could be caused by a couple things:
- The DIM table originally had a filter for active rows that was removed and now it's showing all versions of the rows from the warehouse
- The update from the fact table changed the relationship to the dim table and now it has to process through that change against all the rows in the fact table against all rows in the dim table.
I would verify your power query for the dim table as well as the relationship between the dim and the fact to check for any potential changes. Since you mentioned that the fact did change it is a very good possibility that the change is the issue
