Missing rows when extracting data to a Excel file

[Vcaze]

Good afternoon.

I'm facing an issue in Power BI that I can't solve, and I hope you can help me.

I've created a report to be shared via the service with users who have access to it. One of the requirements was for it to have a table that allows exporting data to an Excel file. Since Power BI only allows a download of 150,000 rows, filters were added to reduce the data volume.

However, after extraction, it appears that some rows are missing. I tried to solve this problem by selecting 'show items with no data,' but I still have missing rows in these extractions.

Have you encountered this issue before? Can you help?

Thank you very much.

[MFelix · Accepted solution]

Hi @Vcaze 

The limit is not only considering rows on a visual but also the query limits and visual types alongside if you are refering to a matrix you have the crossing between rows and columns that will change the number of rows.

https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data?tabs=powerbi-d...