Forum Discussion
Number format from SSAS cube lost
I have a number of measures defined in my multidimensional AS cube where the number of decimal places is explicity set, either directly against the incoming database measure or in a cube calculated m...
nsam101 Are you connecting live or importing data. Becuase if you're importing then you can control data format and type via query editor and under Modelling tab. If connecting live I would suggest you change format under cube and see if it makes any difference. I have seen this before and I would also suggest you submit it as a bug here.
I'm connecting live. I have tried changing the formatting in the cube, and although it's reflected in Excel pivot tables it's ignored by Power BI. So it does seem like a bug to me.
We have same issue here (measures in % in a cube, but displayed as decimal in PowerBI). I was just starting my research, but it seems it's a real issue.
