This is a big problem if totals summing stuff up simply do not work or data is simply missing completely.
1. Which Power BI desktop version did you run? How about the result when you try the latest version 2.49.4831.521 64-bit (August 2017).
2. Please check if the issue happens when you get data from this specific data. You can try to get data from other SQL table.
3. Please check if the issue related to the second step (I have performed minor enhancements after it's pulled into the Query Editor (example: Unique Key)). You can jump this step, just get data then apply the change to see if the same issue occurs.
I have tried unique keys.. I have even slimmed the data down to records related to a series of keys (5) that all relate to the same account. I can physically see the five in query editor preview not in the dataset report viviews. Regardless of how I manipulate and get data, the same issue occurs.
Yes I have upgrade to August's version. With so many problems occuring with Microsoft, the environment, data publishing issues, premium workspaces unable to be created, and more going on with pbi.com, I wonder if this isn't part of it.