Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I want ot display a table from SQL server as is in PowerBI Table visualization. However, PowerBI seems to remove the duplicates from the table when charted.
Table in Query Editor with duplicates :
When the table is displayed as 'Table' visualization:
Is there a way to change this behaviour and d
Solved! Go to Solution.
@Abhaykumar - You could also add an Index column to your query on import so that you have a unique number. Power BI is first and foremost a data aggregation and visualization tool, it sort of assumes you want to DO something with the data, not just display it raw.
That being said, surprisingly, I have not see this posted in Ideas, so I would recommend that you submit it and post the link back here so we can vote for it.
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |