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 amitchandak ,

Please find the data format for your reference,

1. Yes, I want to explore the average's Logged Hrs per user wise once the complete 30 days over then will take month wise how hrs the ID would have.
2. As here following data base, I should we explore in Table or Matrix visual. I'm expecting What is my sources i'm attaching here smae wnat o see in POwer BI data set post imported.

 

 

User
date
ID
Tot. Logged Hours
Gokul
29 May 2023
1000780
24:12:00
Prakash
17 May 2023
34932
26:56:00
Arul
30 May 2023
34932
24:36:00
Kannan
23 May 2023
20588
25:07:00
a
12 May 2023
1092579
24:08:00
b
16 May 2023
1078407
25:25:00
c
25 May 2023
1078407
24:05:00
d
26 May 2023
1078407
24:10:00
Anu
29 May 2023
1078407
24:25:00
Aravind
11 May 2023
1078818
24:33:00


Thanks,
Gokul

  • 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