Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
sharpiejas
New Member

Data changing from excel

Hi,

 

When i import the data shown here 

sharpiejas_0-1727786242718.png

it changes to this

sharpiejas_1-1727786340386.png

 

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?

 

 

1 ACCEPTED SOLUTION
MNedix
Super User
Super User

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:

 

MNedix_0-1727791059140.png

 

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



If the post helped then please give it a Kudos and mark it as the solution so others can see it.
Cheers,

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

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.

vzhouwenmsft_0-1727849414170.png

 

Best Regards,
Wenbin Zhou

MNedix
Super User
Super User

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:

 

MNedix_0-1727791059140.png

 

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



If the post helped then please give it a Kudos and mark it as the solution so others can see it.
Cheers,

Helpful resources

Announcements
Join our Fabric User Panel

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.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.