Displaying Time from an Azure Analysis Services Model

[Anonymous]

I have a report which is direct connection to an Azure Analysis Services tabular model. Two of the fields are for displaying the start and end time of a particular event. The underlying data is in SQL Server with a data type of TIME(0) and my Tabular model has the Data Type set to DateTime with a format of hh:mm AMPM.

When I return this data in Power BI, it's showing it as a date, not a time:

If a query the same dataset using the Analyze Excel function in Power BI, it displays as I would expect it:

Anyone have any clues as to how get this to display properly in PBI?

The fields are both used in a DAX calculation which evalulates whether a delivery occurs within it's timeslot, so fudging the field to display the time as text won't work as it breaks the DAX calc. I need it remain as datetime data type.

My last ditch soltution is to create a second set of columns, with a formatted time in them using text, so users can drag these on to the report and display the right value, whilst the DAX can use hidden columns that retain the datetime data type columns for calculation purposes.

However, in the interests of keeping my data model lean, I'd prefer to avoid adding extra columns. I'd prefer if this would "Just work".

[taistep]

Hi, have you solved the problem? I have the same issue, and I haven't found a valid help in others' issues...

[v-eachen-msft]

Hi @Anonymous ,

After my tests, I couldn't reproduce this issue. You could try to change Data Type to other type in your tabular model.

If this issue still exists, you could create a support ticket here.

[Anonymous]

Have you set the fields in PowerBI to type Time?

[Anonymous]

It's a direct connection to an Analysis Service Cube, so you can't alter the the data formats. It just inherits whatever is under the hood on SSAS