Forum Discussion
Losing Data when exporting a table to Excel
Hi, so my problem is that whenever I try to export a table I've been working on Power BI desktop to an Excel sheet, I lose about a hundred lines of important data from the table. I've never noticed this happening before and now It does all the time. I don't know if maybe it's something on the settings of Power BI or Excel, or maybe I've been exporting the table the wrong way. Can someone help me?
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.
3 Replies
- Bibiano_Geraldo
Super User
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.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
