cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
alexdurok Helper I
Helper I

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

14 REPLIES 14
Super User IV
Super User IV

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

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.






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





alexdurok Helper I
Helper I

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

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.

 

Before-Ater-Dec-16-update.JPG

Braggilicious
Frequent Visitor

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

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

alexdurok Helper I
Helper I

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

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

Highlighted
Community Support
Community Support

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

Hi @alexdurok,

 

You can take a look at below thread which has the same issue:

Percent display issue in charts in olap live connection

 

For your requirement, you can vote it below:

Better support for SSAS MD formatting

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI
alexdurok Helper I
Helper I

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

@v-shex-msft 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.
Community Support
Community Support

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

Hi @alexdurok,

 

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

 

This issue has already submit in ICM, but it hasn't fixed at the moment.

 

 

Regards,

Xiaoxin sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI
jmford
Frequent Visitor

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

I also just lost SSAS % formatting today which was working ok previously.

alexdurok Helper I
Helper I

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

@v-shex-msft: do you have an ETA on that fix? It seems that many people are now facing the same issue whereas few weeks ago it was working well. Could you please have someone from MS reach out to me directly? I would be glad to quickly show him the issue.

 

Thanks 

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors