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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!