Hi,
I'm puzzled here.
I have the below dataset in my source db (it's not identical but close enough for this example):
Time User Company Document DocType Code
17/07/17 23:05:00 admin EGL11 test.doc doc 123
26/01/17 16:48:00 Amy BB123 whiteboard.png png 987
26/01/17 16:48:00 Amy BB123 work.xlsm xlsm 987
17/07/17 23:05:00 admin EGL11 test.doc doc 123
When viewing the table content in the Power BI Query Editor it has the exact same dataset as above.
When viewing the table content in the Power BI Desktop it has the exact same dataset as above.
However, when viewing the data in the 'Table' visual it shows:
Time User Company Document DocType Code
26/01/17 16:48:00 Amy BB123 whiteboard.png png 987
26/01/17 16:48:00 Amy BB123 work.xlsm xlsm 987
17/07/17 23:05:00 admin EGL11 test.doc doc 123
Why has one of my entries for the User: Admin disappeared?
My two entries for User: Admin were identical for every column in the row. Whereas the there are two columns where the User: Amy are different which therefore makes the row not identical.
I cannot see any filtering (thinking it was removing duplicates). I cannot find anywhere where it looks for distinct values and therefore would look to remove the duplicate row.
Does the 'Table' visual remove duplicate entries, based on columns, by default?
Thanks.
