Time Stamp missing - PowerBI SSAS cube live connection

[bvpenumalli]

I have PowerBI report that is connected to SSAS cube via live connection.

When I browse cube through SSMS it shows time stamp in the data column, but in the PowerBI report it is missing the time stamp, but shows just the date.

[suhasakole]

Hi @bvpenumalli 

Can you check the data type of your column? if its only Date then it will show only date. Please change to Date/Time to get the time stamp.

Hope this will help you.

[bvpenumalli]

Thank you for your response, it is set as DateTime in SSAS cube, when I browse SSAS cube via SSMS it shows as date time.

[bvpenumalli]

Where in PowerBI we can specifically set data type ?

[Anonymous]

If its live connection to SSAS, you cant modify the data type, that needs to be handled in the tabular model or you may need to create a report level measures to set data type.