SSAS Time dimension doesn't work... hh:mm:ss in power query, the year 1899 in the model

[Anonymous]

I have a date and a separate time (hours, mins, secs) dimension and I can get the date to work linked to date on the date dimension but I can not get the time dimension to work.

It looks good in power query time is hh:mm:ss and then it gets immported into tabular model and the time turns to  /1899 and I can't get it to work.

Is there a way to explicitly ensure that it is entered as a time dimension?

I'm considering giving up with SSAS and just loading everything into Power BI.

Any thoughts gratefully received... I can post the code. I will have to cite the website I got it from as it isn't mine, its borrowed

[dax · Accepted solution]

Hi @Anonymous , 

You could try to change type to Time in M code(after import data in powerbi, you could click Edit Queries to change type) to see whether it work or not

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

l will try this...thanks for the tip 🙂

I have decided to just use Power BI and it works fine there.