Export to Excel Missing Data

Hi all,

I have come across a similar problem, when exporting data from tables created in Power BI only half of the rows are being exported.

Tables with a maximum of 2,500 rows are only exporting 800 - 1,300 rows. This problem also appears to be indiscriminate.

I have advised a client to use Power BI and helped them set it up but now this problem has caused a problem on 2 occasions. Fortunately, the first time, after closing and restarting Power BI Desktop, it exported the full count of rows. The second time though, the problem persisted to the point where instead of exporting only half of the rows it began to return an error. The client shared the pbix file with me and after initially it only returned half of the rows I repeated the procedure 4 times and each time got the full row count. This was despite the fact that I did not change anything in the file as sent by the client.

Is there a clear explanation as to what might cause this problem?

Any suggestions or tips would be gratefully received.

Kind regards