Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Formatting SSAS values with a Live connection - (WAS working until November 2016)

Hello everyone,   I have been creating Reports based on a SSAS live connection since a year with calculated measures formatted directly in SSAS with "+#,##0.00%;-#,##0.00%".   Data was showing up...
Need Help
Braggilicious's avatar
Braggilicious
Frequent Visitor
9 years ago

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. "

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Thanks Braggilicious to post the engineer's feedback. He seems to say that formatting from SSAS (from semantic layer) is not supported, but in the example above it shows that before December 2016 the formatting from a SSAS live connection was perfectly working.

     

    We can't use any DAX fonctions on top of a live connection. This formatting issue is a big concerns and makes the reporting not user-friendly at all.

     

    Let's see if we get help from Microsoft.

     

    Thanks for your help guys

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago
        Anonymous thanks for your feedback. I voted for that functionality let's hope that it will be accepted and released soon because it's clearly a basic but a must have.

        However we are talking here about a fix (at least for the %) and not a new functionality as it was clearly working up to November.