Losing Data when exporting a table to Excel

[Data_Management]

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?

[Bibiano_Geraldo · Accepted solution]

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.

[Data_Management]

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