Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Time issue

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
Comments
Anonymous
Not applicable

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

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