I am currently using the latest Power BI Desktop verison (July-2018) and noticed something odd. I am importing from a table from SQL and then using the power query editor to clean my data. Once the data is cleaned is shows about 400 records. I then proceed to Close and Load data and then only 13 records are available in table. When I refresh and flip back and forth between the query editor and the table in data view the number of records dont match.
I noticed this the other day with another report and after closing desktop and refreshing data a few times it just seemed to fix itself.
Anyone else notice this? I am concerned as my report that end users are using is not showing all records. Strangely the report has been refreshing daily without issue.