Forum Discussion
Power query row count changes when refreshed
Thanks! So I did a test where I have a text file as my data source and that file has around 1.3 million records in it. I referenced the query bringing in the data source and the only transformation I did in the reference query was to filter the table on a particular field. I then loaded the resulting table into Excel. The first time I did that the table had 25,162 records in it. I then refreshed and, with no changes to the text file, the refreshed table that was loaded has only 25,134 records in it. If I refresh a third time, the table has only 24,780 records in it. The same thing happens if I repeat the experiment in Power BI. The data loaded into the data model changes quantity every time I refresh.
That definitely should NOT be happening. It is possible your cache is corrupt. Try clearing it in Power BI.
If that doesn't help, then I'd either need to see the text file (if it isn't confidential info you can share via a OneDrive link here in the forum) or you should raise a support ticket.