Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
harald47
New Member

Date/Timestamp format in PowerBI via SSAS tabular Cube

Hello, im trying to display timestamp in PowerBI and got a live connection to a SSAS Cube.

How can i display the full timestamp? Im not able to use PowerQuery while using an SSAS Cube.

 

This is how it looks: 

harald47_0-1699514985345.png

 

This is the data in the SSAS Cube: 

harald47_1-1699515020210.png

 

1 ACCEPTED SOLUTION
Chew_WenJie
Resolver II
Resolver II

Hi,

 

You can configure the properties on that SSAS cube column and change the date format to HH:MM:SS then in power bi it should be display correctly.

 

Chew_WenJie_0-1699518738168.png

 

View solution in original post

2 REPLIES 2
Chew_WenJie
Resolver II
Resolver II

Hi,

 

You can configure the properties on that SSAS cube column and change the date format to HH:MM:SS then in power bi it should be display correctly.

 

Chew_WenJie_0-1699518738168.png

 

Thank you, that worked for me!

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.