Forum Discussion
ShrutiJ
Helper II
Helper IIExport functionality exports less rows in excel
I have a report with table visual which has ~80K records and published in a workspace. When I export the data of this visual, it exports ~28K records only although the limit is 150K. When I remove fe...
aj1973
Community Champion
Community ChampionHi ShrutiJ
Here are the limitations cited in this link
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data
ShrutiJHi aj1973
The only limitation mentione din the link if of the number of rows. In my case, when I reduce the columns, the rows increases even though the total number of rows are less that the mentioned limit.
- aj1973
Hi ShrutiJ
I am afraid to tell you that limitations for an excel sheet is not only the number of rows. The 150K rows is the maximum that Power Bi can export, the rest can be found here.
So I am guessing that your report is facing one of the limitation mentioned in the site and you will need to find out! Note that the Excel version that you are using can also apply some limitations.