cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TheMartha Frequent Visitor
Frequent Visitor

Formatting SSAS values (Live connection/explore live)

I want to see my date as Date and not as DateTime.

The data comes from a cube - SSAS. If I use excel, the date shows as it should. But when I get the data for a PBI report and I start connecting data from the desktop - using PCG, I will get the datetime and not the date.

It is not possible to format because I do not have the buttons to go back the system (like to do DAX) and stuff. Somebody there with the same kind of issue? Help Please. (Live connection)

/The Martha

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-sihou-msft
Moderator

Re: Formatting SSAS values (Live connection/explore live)

Hi @TheMartha,

 

Currently, Cell level Formatting and translation features are not supported in this release of SSAS MD. These features will be enabled in upcoming releases of Power BI Desktop. Even you use FORMAT() function, it will still take the source format.

 

Capture.PNG

 

See "Limitations of SSAS Multidimensional Models in Power BI Desktop" in link below:

Connect to SSAS Multidimensional Models in Power BI Desktop

 

Regards,

View solution in original post

5 REPLIES 5
Moderator v-sihou-msft
Moderator

Re: Formatting SSAS values (Live connection/explore live)

Hi @TheMartha,

 

Currently, Cell level Formatting and translation features are not supported in this release of SSAS MD. These features will be enabled in upcoming releases of Power BI Desktop. Even you use FORMAT() function, it will still take the source format.

 

Capture.PNG

 

See "Limitations of SSAS Multidimensional Models in Power BI Desktop" in link below:

Connect to SSAS Multidimensional Models in Power BI Desktop

 

Regards,

View solution in original post

BarryB75 Regular Visitor
Regular Visitor

Re: Formatting SSAS values (Live connection/explore live)

Have their been any updates to being able to format, model, and add measures/columns to live connections?  Any ETA on when this will be possible?  REALLY need this feature.

Super User
Super User

Re: Formatting SSAS values (Live connection/explore live)

@BarryB75 Status on the request still shows "Under Review" from June...

 


Near SE WI? Join our PUG Milwaukee Brew City PUG
BarryB75 Regular Visitor
Regular Visitor

Re: Formatting SSAS values (Live connection/explore live)

Thank you for the quick reply.  Hopefully they will make it happen soon.   It's pretty frustrating at the moment.

Highlighted
chetanamare Regular Visitor
Regular Visitor

Re: Formatting SSAS values (Live connection/explore live)

Is it still "Under Review". It's been a year and still there is no solution to the date issue using live SSAS connection.

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)