The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Anybody can ask a question
Anybody can answer
The best answers are voted up and moderated by our team

PowerBI and Duration data type

PowerBI and Duration data type


Can any help solve this problem.
I’m trying to load data that includes duration into PowerBi. 
When I try to transform,  it either creates error or states it cannot be a duration data type.
I’ve tried adding a custom column and transforming into decimal and then to duration.
Additionally, where it does look like it’s a duration data type wherever its over 24:00:00 (24 hours) is displays an error too.
I’m new to Power BI and getting duration columns to work is impossible.

2 Answers

365 Team

Hi Georgina,
You can try converting the duration to seconds by using Duration.TotalSeconds([Column]) inside PowerQuery. If you need any additional help or don’t want to disclose any sensitive data, you can drop me a PM.

Kind Regards,
Dimitar Shutev


I’ll give it a try and let you know.

Learn Data Science
this Summer!
Get 50% OFF