I have a report which uses an live connection to an onpremise SSAS instance and cube. When viewing/designing the report in PowerBI Desktop, all measures return correct values and totals. When I publish the exact same report, the measure is divided by 10000 and incorrectly totals. There is nothing special about the measure, no calculations, no custom aggreations. I have even reinstalled the on-premise gateway a number of times, but I still get the incorrect results in the published version of the report. I have even attempted to create the report online, rather than use PowerBI Desktop, and I get the incorrect result. Any troubleshooting hints, or advice would be appreciated. Different results in a live connection are concerning.
... View more