Forum Discussion
Data in Power Query is different from data loaded into the model
Hi! I have a scary problem, and can not understand why it happens. It is the first time I observe such behaviour in several years. The Data I observe in Data model is not the same as in Power Query...
Just in case it an help someone - it looks like the reason was not in joins, but in one of the further transformation I made. These were Custom Columns. When I removed these custom columns , the data started loaded normally. I am still trying to figure out what it has been. I actually did not do anything illegal, these were column with plain if/then rules. And creating such columns should not have changed the data in other columns on load to data model! I made these custom columns in DAX instead.
Do you know what – within the Custom Columns – caused the problems?
