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.