Incorrect Duration Format transformed from Excel to Power Bi

Question

Hi, I have a Duration&nbsp;data is&nbsp;191:33:04 in Excel, I want to visualize it in Power BI. What&nbsp;is the best solution?&nbsp;Data in Excel 191:33:04,&nbsp;when I imported in Power BI, it changed to 7/01/1900 11:33:04PM&nbsp;Can you please advise how can I measure it in Power BI?&nbsp;Thanks in advanced.

v-yulgu-msft · Accepted Answer

Hi&nbsp;Anonymous,&nbsp;Here is a similar thread for your reference:&nbsp;Data loading incorrectly, Issue with data type of data.&nbsp;Best regards,Yuliana Gu

Forum Discussion

Incorrect Duration Format transformed from Excel to Power Bi

2 Replies

Related content

Issues transforming text to duration

Table Transformation

Transform columns / type

Data transform using power query

Table Transformation