Forum Discussion
Formatting SSAS values (Live connection/explore live)
SSAS is a semantic layer in BI. This means it stores metadata natively with data. Part of this metadata is display formatting. Power View (the report component in Power BI) is designed, for better or worse, to defer to the display format metadata of its source. You should alter these display formats in your SSAS model.
I've had to raise a premier support ticket on this to get any response from Microsoft. From the support engineer:
"After our local investigation, we found we can actually reproduce similar symptom in our local house. Basically in the backend Power BI will fire DAX queries against Cube directly (we call it DAXMD). At this moment, DAXMD still does not support formatting, so currency does not delegate over. "
Hello Braggilicious,
Thanks for your message. Unfortunately the support engineer's answer is partially incorrect when he says:
"At this moment, DAXMD still does not support formatting, so currency does not delegate over "
Maybe since the December 2016 update that is true, but before the formatting from a SSAS live connection was perfectly working.
Since that topic is considered as closed with an accepted answer, I created a new topic where you can see the difference before VS after the update here http://community.powerbi.com/t5/Desktop/Formatting-SSAS-values-with-a-Live-connection-WAS-working-until/td-p/110172
Hopefully your contact can have a closer look at the issue.
Thank you
I have the same issue. All SSAS MD formatting abruptly lost in PowerBI on 19th Jan. Please fix ASAP.
