Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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.
l will try this...thanks for the tip 🙂
I have decided to just use Power BI and it works fine there.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
53 | |
21 | |
13 | |
11 |