Forum Discussion
Export report data with current layout as is and not remove duplicates
Hi bslintx , Thank you for reaching out to Microsoft Fabric Community Forum.
Power BI removes duplicate rows during exporting data if it thinks they are duplicates. Adding an index column (auto ID) should help prevent this, but you must set it to "Don't summarize" in your visual. This stops Power BI from grouping rows.
Check that your relationships between tables are set correctly. Your relationship between your tables should be "One-to-Many" and set to "Single" to have the right control over your data.
When exporting, try to export raw data from a table itself instead of trying to export it from a visual because that might cause aggregation. Whenever you use "Keep Duplicates" in Power Query, this causes the record count to drop. Other steps or filters may inadvertently remove your data. Check for any filters or transformations in the query that might be deleting records, such as filtering out nulls or joining with other tables. Make sure that your relationship between your tables is correct: the parent table should have unique IPs, and the child table (vulnerabilities) should have multiple entries for each IP. The "Don't summarize" setting prevents Power BI from merging rows that have the same index value. Right-click on the index field in your visual and select "Don't summarize" to include all records without aggregation.
It is my understanding from reading your 3rd edit that your problem is solved. Can you please confirm the same or if you still have any issues, please share them.
If this post helps, then please consider to 'Accept as solution' to help the other members find it more quickly.
Community SupportHi bslintx , Thank you for reaching out to Microsoft Fabric Community Forum.
Power BI removes duplicate rows during exporting data if it thinks they are duplicates. Adding an index column (auto ID) should help prevent this, but you must set it to "Don't summarize" in your visual. This stops Power BI from grouping rows.
Check that your relationships between tables are set correctly. Your relationship between your tables should be "One-to-Many" and set to "Single" to have the right control over your data.
When exporting, try to export raw data from a table itself instead of trying to export it from a visual because that might cause aggregation. Whenever you use "Keep Duplicates" in Power Query, this causes the record count to drop. Other steps or filters may inadvertently remove your data. Check for any filters or transformations in the query that might be deleting records, such as filtering out nulls or joining with other tables. Make sure that your relationship between your tables is correct: the parent table should have unique IPs, and the child table (vulnerabilities) should have multiple entries for each IP. The "Don't summarize" setting prevents Power BI from merging rows that have the same index value. Right-click on the index field in your visual and select "Don't summarize" to include all records without aggregation.
It is my understanding from reading your 3rd edit that your problem is solved. Can you please confirm the same or if you still have any issues, please share them.
If this post helps, then please consider to 'Accept as solution' to help the other members find it more quickly.
Hey there!.....
Thanks for taking the time and posting a solution. You are correct > Edit 3 was the fix action. I had an index column but the 2 important things to ensure:
1. Set to not summarize
2. The index must be included (checked) in the visual
Again, appreciate your assistance!