@itayrom, great minds think alike... I too, am "doing it on the database". Still, this issue is obviously not normal. Will post here if support comes up with a resolution.
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.
Sorry, forgot link to new version: https://www.microsoft.com/en-us/download/details.aspx?id=45331
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.
Thanks for letting me know about the update.
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.
Datasource is Postgresql.
One other has complained in the issues section of the site here: https://community.powerbi.com/t5/Issues/AWS-hosted-Postgres-Connectivity-Issues/idi-p/483047