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,
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,
I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.
Regards,
Harshitha.