Forum Discussion
LEFT OUTER JOIN is missing data in data view
Anonymous - I tried your suggestion and it didn't work, but it did lead me to the solution (I was creating a sample file that displayed the power query data differently). It turns out I mistakingly assumed that my UserID columns were lowercase as power query displayed them as such. In reality, the ChildID from the 2nd table was actually in uppercase. I transformed that column into lowercase and now my data is being displayed correctly! Thanks for the help!!
This happens to me from time to time. As cliche as it may be, have you tried closing down the file and then re-opening? That seems to fix it from time to time. If that doesnt work can you upload some sample data to see if we can replicate the issue?
Anonymous - I tried your suggestion and it didn't work, but it did lead me to the solution (I was creating a sample file that displayed the power query data differently). It turns out I mistakingly assumed that my UserID columns were lowercase as power query displayed them as such. In reality, the ChildID from the 2nd table was actually in uppercase. I transformed that column into lowercase and now my data is being displayed correctly! Thanks for the help!!