Forum Discussion
Helper VExporting data is not showing all the rows
Hi syasmin25
There are some limitations when exporting data from a visual, you can refer to this article:
-
The maximum number of rows that can be exported from Power BI Desktop and Power BI service to .csv is 30,000.
-
The maximum number of rows that can be exported to .xlsx is 150,000.
-
When using DirectQuery, the maximum amount of data that can be exported is 16 MB. This may result in exporting less than the maximum number of rows, especially if there are many columns, data that is difficult to compress, and other factors that increase file size and decrease number of rows exported.
-
If the visual uses data from more than one data table, and no relationship exists for those tables in the data model, only data for the first table is exported.
In your scenario, please check if you hit one of the limitation. If not, please clarify "I have this bug in multiple reports where when you export a table less than half of the rows are actually included in the excel file". If possible, please share a issued report with us to reproduce the issue.
-
I have found something interesting with exporting data from grids that might be relevant. Many answers will point to missing data due to record count limitations of exports or errors in your transformations when loading data, but I have seen something else.
Lets say my data is showing sales qty data for a region, territory and location.... the data might look like this:
Region Territory Location Qty
North PA Philly 100
North PA Philly 100
North PA Pittsburgh 150
North PA Pittsburgh 200
The data above is coming from different, related tables, and when it is dispalyed in a grid, even if I do not choose to sum the Qty field, it only displays 1 row, but does sum up the rows that have completely duplicated data, and looks like this:
Region Territory Location Qty
North PA Philly 200
North PA Pittsburgh 150
North PA Pittsburgh 200
But when I export the data to a CSV file, the data looks like this:
Region Territory Location Qty
North PA Philly 100
North PA Pittsburgh 150
North PA Pittsburgh 200
So as it stands, the grid is rolling up the numbers, but when it is exporting, it only exports 1 row for each duplicate. I think this is a bug in the grid export feature, and the work around is to add another column to the grid that would force those duplicated/rolled-up rows to be unique an not rolled up.
I just found the exact same issue. In my scenario, there are legitimate duplicate rows, so my solution was to add an Index column to the dataset, forcing uniqueness. This fixed my issue.
Susan513Helper II
You are right - I have columns with the same data and was shorted those rows. I added another coumn (which is unique and I don't need) and this then pulled all the rows. Come on Microsoft, dumb!!
