Shifting Decimal Places
Duplicated, with a dead-simple example. I created a new fact from a named query, and built a cube from that fact (and a test dimension). Create a live query connection to that cube via the Data Gateway. That's it.
Source for my test fact:
SELECT 1 AS TestSID, 1000.5 AS RawMeasure, CAST(1000.5 AS money) AS MoneyMeasure, CAST(1000.5 AS float) AS FloatMeasure
UNION ALL
SELECT 2 AS TestSID, 1234.56 AS RawMeasure, CAST(1234.56 AS money) AS MoneyMeasure, CAST(1234.56 AS float) AS FloatMeasure
UNION ALL
SELECT 3 AS TestSID, 999.9999 AS RawMeasure, CAST(999.9999 AS money) AS MoneyMeasure, CAST(999.9999 AS float) AS FloatMeasure
Note that in the cube, I changed the data type for the "Money Measure" from Double to Currency, to match the source query data type. This is important.
Output in Power BI. Look at what it does to the Money Measure.