I have created a report in PowerBI that uses data connected through SAP BW. When I refresh the report in the desktop app everything works fine. My numbers are showing correctly and all there is left to do is publish. When I publish the report I see the numbers matching but after anywhere from 2-5 minutes if I refresh the report or open it in a new window the report breaks and hardly any of my data shows up. All the while this is happening my numbers in the desktop version are still in tact. I have not had any issues refreshing the Desktop, just publishing the online version of the report.
I initially thought it may have been some kind of boolean error or maybe my Sharepoint securities were messed up since I do have some excel files connected from Sharepoint. But later realized if I just throw the revenue (that comes straight from SAP) onto a table and publish, that only sums to 90% of my total revenue on the published screen. In sumary some of my data shows when publish but I'd say 90-95% of it does not.