Forum Discussion
Losing Data when exporting a table to Excel
Hi Data_Management
Power BI has a 30,000-row limit when exporting data, so if your table exceeds this, it may truncate the export. Check if any filters are applied, as they could limit the data being exported. Ensure you're using a standard table visual, as some complex visuals might not export all data.
Super UserHi Data_Management
Power BI has a 30,000-row limit when exporting data, so if your table exceeds this, it may truncate the export. Check if any filters are applied, as they could limit the data being exported. Ensure you're using a standard table visual, as some complex visuals might not export all data.
Hello @Bibiano_Geraldo, thanks for the reply. The table I'm working with is a simple model, I did have some filters on as they're essencial to get the exact info from my database, I'm gettin the data from a few different tables that come from different sources, and like I said, this never happened to me before, working with the same datasets. I recently tried exporting it with the filters turned off and it worked. Still don't know what happened though. Anyway, thanks for the help!
- Bibiano_Geraldo
Happy for you Data_Management, you're welcome
