Forum Discussion

sanderson82's avatar
sanderson82
Icon for Helper I rankHelper I
7 years ago
Solved

Date 1 day behind (SP Datasource)

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