So, this is logged over in ideas.powerbi.com. However, It's really a bug that can cause problems with report integrity and trust of users for reporting. Table visualizations cannot display duplicate rows. This is with summarization turned off for every field on the table, which is a separate pitfall. In SQL terms, the table visualization acts like a UNION, but it should act as a UNION ALL.
The workaround for the present is to do as advised in the forums, which is to add a unique column to the table visualization and then shrink the column width in order to hide it. In one case recently, however, I had to add an index to my query and then hide that column (with word wrap on, this hack also had the effect of resizing my rows to accommodate the wrapped but hidden index field). My users would like to see, for example, that a check detail has two line items for exactly $51. And I would prefer not to have to build workarounds.
mattlee
on:
Input Text Slicer Broken on PBI Services
on:
Connection Timeout to Azure Analysis Services (AAS...
on:
CMD Prompt Popping Up During Changes