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.
Interesting. I have never seen this behaviour. So you think you found a severe bug. Microsoft will probably want to see your m code ...
May be you file is corrupted. If you work in excel, you can copy paste all your queries to a new file and see if it makes a difference.
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.