Forum Discussion

Gokul_G16's avatar
Gokul_G16
Icon for Resolver I rankResolver I
3 years ago

Greater than 24 Hrs Time format error data sources Excel into Power BI

Hi Connections / Arul  Thennarasu_R  amitchandak  Since have been facing the time fornat while i'm imported Excel Scources into power BI, When ever the data feed as showcasing the More than 24 hrs...
data protection
General Comment
Need Help
Show and Tell
Gokul_G16's avatar
Gokul_G16
Icon for Resolver I rankResolver I
3 years ago

Hi Arul ,

Thanks for forwarding, We should be convert time into seconds while we import Power BI, Then we can able to see the Time >24 hrs values in Power BI..

Try it this once you imported into data in Power BI in back end : 

Duration.TotalSeconds([MyData] - #datetime(1899,12,31,0,0,0))

Thanks,
Gokul