Forum Discussion
missing data
Ah ok got it. Then this might be due to implicit GROUP BY in Power BI: If you're using a visual (like a table) without all columns, Power BI automatically aggregates duplicate rows. Check if "Don't summarize" is set for all columns.
I look, no filter is applied.
Hi Vivo ,
Check the visual settings:
Go to your table visual in Power BI.
For each column, click the dropdown arrow and select “Don’t summarize”.
This tells Power BI to display each row exactly as it is without aggregating.
Check Power Query steps:
Open Transform Data → Power Query Editor.
Make sure no “Remove Duplicates” or filters were applied accidentally.
If needed, load all columns to maintain uniqueness.
Verify by adding an index column
In Power Query, you can add an Index Column to ensure each row is unique for visuals.
This guarantees that even fully identical rows are displayed separately.
If you still can't resolve the issue, please provide the sample Pbix file. How to provide sample data in the Power BI Forum
You can refer the following link to upload the file to the community.
How to upload PBI in Community
We are available to support you and are committed to helping you reach a resolution.
Best Regards,
Chaithra E.