Forum Discussion
Merge Table Switching Column Selection
Based on all my research it seems to have something to do with the filters and sorting that i am doing in one of the dataflows. Microsoft does not seem to like that because the moment i remove those then the merge works fine. I've found a different way to approach my needs that seems to work now but really frustating that power bi is this sensitive to data manipulation sometimes.
Super UserMost likely cause: you did it yourself. Happens to me all the time...
Easiest remedy: change the M code yourself.
Nope didn't do it myself. I've retried the merge about 20 times now and it does it every time. The code show it correctly but when i open the merge details it shows it incorrectly. I've tried sorting the columns into the order it keeps changing it to and that kind of helped because now the columns are staying the same but now it shows me that i have no data when i pull in the columns, even though i cleary see i have data.