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.
Still yet to receive response from MS support, but reverting back to June 2018 version of desktop app solves issue (which renders all pbix files edited after July install incompatible). Now it's wait & see if there are any scheduled refresh issues this evening as our enterprise gateway is July version. Ugh.
Downloaded and installed the latest July 2018 Power BI desktop. This did resolve my issue on the desktop version. I will now wait to see what happens over night for when this report is scheduled to be refreshed.
My issue is exactly the same. I built a simple diagnostic and the table that fails loads exactly 1000 rows when it fails. I have the new August release of desktop which works fine 100%. It's when I load to the service that it fails approximately 50-75% of the time. On prem gateway is July release.