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 perfectly with the % in Card, muti-row or matrix tables but I noticed that since December 2016, the formatting is no longer working in Power BI Desktop/Online.

 

Could you please help me out?
Thank you

Need Help

15 Replies

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    9 years ago

    Wow I'm also using SSAS , and not sure about this formatting issue. I'm sure PowerBI team will able to explain it better. Thanks for bringing this up.

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      I found a test report created early in September 2016 based on a SSAS live connection where we can see the correct formatting. By chance, that report failed to update since mid-november due to a measure in our cube that no longer exists. But at least it shows that it was perfectly working.

       

      On the picture below (sorry for the quality), you can see the formatting of the same measure before and after the December 2016 update.

       

  • 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