Hi,
When i import the data shown here
it changes to this
When i try to transform the last coloumn to duration, i get an error.
Would someone be able to talk me through a soloution please?
Heya,
You have to properly format the column in Power Query (Transform data) when importing the Excel. I did the same table and imported it in PBI and got the below result:
However, I don't knwo what you're trying to achieve but the difference between those dates/times should be 1 Day and 3:06:20
If this solved your problem then please mark it as the solution so others can see it.
Cheers
Hi MNedix ,thanks for the quick reply, I'll add more.
Hi @sharpiejas ,
Regarding your question, look at the steps in your Power Query and see if there is a 'Change Type' that changes the data type to a number.
Best Regards,
Wenbin Zhou
Heya,
You have to properly format the column in Power Query (Transform data) when importing the Excel. I did the same table and imported it in PBI and got the below result:
However, I don't knwo what you're trying to achieve but the difference between those dates/times should be 1 Day and 3:06:20
If this solved your problem then please mark it as the solution so others can see it.
Cheers
Helpful resources
Join our Fabric User Panel
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Power BI Monthly Update - June 2025
Check out the June 2025 Power BI update to learn about new features.
Fabric Community Update - June 2025
Find out what's new and trending in the Fabric community.
