Forum Discussion

HenryH's avatar
HenryH
Regular Visitor
10 years ago

SharePoint date differs from Power BI date

Hi,   I have imported data from a SharePoint list into Power BI including one column containing a date. The date in Power BI differs 1 day from the date in SharePoint. e.g. Sharepoint: 1/6/2016 >...
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Just came across this thread when having the same issues. I seem to have sort of worked it out, I have a Date/Time column in SP that comes in as text to Desktop and it is jumping ahead 6 hours. Note this is only for local time I believe.

 

  1. Open Power Query
  2. Change Data Type to Date/Time/Timezone
  3. Change Date & Time Column, Time to Local Time
  4. Change Data Type to Date/Time to remove the Timezone

 

No idea why this is doing it, but it gets me the correct time now. Now, if only there were more visuals that worked with time...

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi

I just followed your steps unrly and it does seem to work, thanks.