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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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