Forum Discussion
Missing rows when extracting data to a Excel file
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.
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.
1 Reply
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.