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 ,
This is a common Power BI behavior, and the discrepancy arises because your table visual is summarizing or aggregating your data. The Data View shows you the raw, un-aggregated 135 rows exactly as they are in your model. However, when you create a table visual on the report canvas, Power BI automatically groups rows that have identical values across all the columns you've chosen to display. This grouping is why you see 116 unique rows in the visual instead of the full 135.
The most effective solution is to force the visual to treat every row as unique by adding a unique identifier column to the visual itself. This prevents Power BI from being able to group any of the rows. If your data already has a column with a unique value for every row, like a transaction ID or a primary key, you can use that. If not, you can easily create one in the Power Query Editor. To do this, click on Transform data, select your table, go to the Add Column tab, and click Index Column. This adds a new column with a unique number for each row.
After ensuring you have a unique column, return to the report view and select your table visual. Drag the unique ID or Index column from your Fields pane into the Columns bucket for the visual. By default, Power BI might try to sum this new numeric column. You must change this behavior. Click the small dropdown arrow next to the column's name in the Columns bucket and select the Don't summarize option. This action guarantees that every single row from your underlying data is displayed individually in the visual, allowing you to export all 135 rows to Excel correctly.
Best regards,