Micorsoft List to Power BI Date Difference.

[JJEvans]

HI all 

I have connected to a Microsoft List as my data source, and i have quite a few Date columns both just date and date and time. However everytime i get it into Power BI it removes an hour from the time, thus taking just the date columns back a day. I have done some research and i thought it had something to do with the regional setting for the time, however whatever i do it still changes the time and date. 

Please see below some screen shots of the different areas and the difference between the list and power BI:

Micrsoft list:

Power BI :

This should all be the same date, and this is suppose to be a date column only. 

Regional setting for the site the list sits:

Regional Settings for the locale import. 

Global Power Bi Regional Settings:

Any help would be much appreciated. 

[lbendlin · Accepted solution]

Behind the scenes everything is DateTime, and everything is based on UTC.  Recommend you use the DateTimeZone type throughout, and then convert to your local timezone at the last possible moment. 

[JJEvans]

I have changed the type to DateTimeZone, and this is how it has come up, i then applied this, but when i go to my data nothing has changed, am i missing something?

[lbendlin]

Looks ok?  Anyway, Power Query has functions to convert timestamps between timezones and to mess around with dropping them etc.

[JJEvans]

I am sorry, i must have been crossed eyed when i looked at this, you are right it has fixed the problem thank you for your help.

[chinfoo]

Hi @JJEvans I'm facing the same issue like your case, i tried above solution (changing to date/time/zone & follow my local timezone) but seem not work. May i know how you get it solved?