Power BI keeps displaying 12:00:00 AM. How can I make it display the right time?

[lloporock]

I'm currently getting the data from a Sharepoint List into my Power BI Desktop.

The time on the Sharepoint list is displayed correctly but when I view it in my Power BI table, it only shows 12:00:00 AM for all of the entries.

i.e: Power BI

But the time is suppose to be, sharepoint list:

How can I get it to display the right time in Power BI?

[Anonymous]

Hi @lloporock ,

This generally happens because when you connect to Sharepoint using Power BI Desktop, it first recognizes the column as a Date type and later changes it to a Date/Time type.
Please check the Data Type in sharepoint and Power Query, and ensure that its data type is set to Date/Time.
Here's another possible reason. When using the SharePoint Online list connector, Power BI does not perform a local timezone conversion as the SharePoint web-based client does. Instead, it reports the UTC time directly, which is why you're seeing the time as 12:00:00 AM. To correct this, you need to convert the UTC time to your local time using Power Query Editor in Power BI Desktop.

#"Changed Type" = Table.TransformColumnTypes(#"Renamed Columns",{{"Datewithtime", type datetimezone}}),
#"Timezone Shifted" = Table.TransformColumns(#"Changed Type", {"Datewithtime", DateTimeZone.ToLocal})

https://learn.microsoft.com/en-us/power-query/connectors/sharepoint-online-list#timezone-issues 

If the above suggestions don't help, could you please provide more details, e.g. what sharepoint connector are you using?

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lloporock]

Hi @Anonymous , I can notice this happen when you select "implementation 2.0" in sharepoint online list connector, but if you select "implementation 1.0", power bi shows the correct hours.