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.
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.
I’ll give it a try and let you know.