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.

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.

back

Follow this topic

Georgina Hall

Last answered:

June 15, 2020

Posted on:

June 11, 2020

PowerBI and Duration data type

2 answers ( 0 marked as helpful)

Dimitar Shutev

Posted on:

June 13, 2020

Georgina Hall

Posted on:

June 15, 2020

Submit an answer

Content