Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

We've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now

SanchezJason

Time issue

Submitted by on ‎11-10-2022 07:07 AM

Hi, 

 

I have an issue with date/time column.

 

I have in a Sharepoint list a date/time column that shows the correct information, but when I load the data to Power Bi desktop the time values change.

 

This is the correct date/time values shown in my sharepoint list

SanchezJason_4-1668092366021.png

 

And this is the date/time values shown in my power bi desktop

SanchezJason_5-1668092395656.png

 

My PC settings are set in Costa Rica and my Power Bi setting too

SanchezJason_6-1668092520984.png

 

 

 

 

Status: Investigating
See more ideas labeled with:
2 Comments (2 New)
Comments
Anonymous
Not applicable
‎11-10-2022 06:21 PM

Hi @SanchezJason 

You can try to change type with locale in Power Query .

Ailsamsft_0-1668133240599.png

I found a similar issue , you can refer to it .

SharePoint date differs from Power BI date - Microsoft Power BI Community

 

Best Regards,
Community Support Team _ Ailsa Tao

SanchezJason
Regular Visitor
‎11-11-2022 01:23 PM

That steps didn't work for me 😞

I need to find the way that power BI detects that it is in the same time zone as my sharepoint list because my SP list is in UTC - 6 but my power bi add again the UTC-6 to the time values

Idea Statuses