Date 1 day behind (SP Datasource)

[sanderson82]

Hi

I have a timesheet app which stores data in a Sharepoint list.  Dates all show correct in the SP list.  When I connect Power BI Desktop and create visuals using the date everything is one day behind.

When connecting to the date I did have to change the date field from text to date.

If I set it to date time they all show 11pm on the previous day.  There I am guessing it's a timezone issue?

Any help much appreciated

[v-chuncz-msft · Accepted solution]

@sanderson82 

You may refer to the following post.

https://community.powerbi.com/t5/Desktop/Created-time-for-records-is-changing-when-connected-to-onli...