Forum Discussion
PowerBI export not exporting all rows.
Hi majidmx,
Thank you for reaching out to the Microsoft fabric community forum.
The reason you see fewer rows in export is because Power BI groups rows in a table visual when all column values are same. That’s why adding a unique ID shows all 135 rows.Right now, there is no other setting that will stop this grouping when you export from a visual. The “export summarized and underlying data” option only helps when you choose Export > Underlying data from the Service, it will not change the table visual export.
So, try these :
Use Export underlying data if enabled by admin this will give you all rows without adding ID.
Or keep using the table visual export with an ID column and remove that column later.
Kindly refer to the below documentation links for better understanding:
https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data?tabs=powerbi-desktop
Hope this helps if you have any queries we are happy to assist you further.
Regards,
Community Support Team.
Hi majidmx
Export uses the visual’s query, not the raw table. If your table visual doesn’t include a unique row key, Power BI groups identical rows (same values in the shown columns), so fewer rows get exported (116 vs 135). No filters are needed for this to happen.
How to get all 135 rows:
-
Best: Export Underlying data (Service >> Export >> Underlying data; requires Build permission + “Allow export underlying data”).
-
Or: Add your table’s Row ID/primary key to the table visual (set to Don’t summarize; you can hide it by shrinking the column) and then export.
Thanks for your request. I am trying to find the setting in the PowerBi Admin Center but I don't see the option. Am I looking in the wrong place?
Best regards
Majidmx