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
v-zhouwen-msft
Community Support
Community Support

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,
avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

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

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)