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 >...
Fyouri's avatar
Fyouri
Frequent Visitor
9 years ago

Hi JamesCook,

 

I have tried your workaround, but it isn't working for me. My workaround was to create calculated columns in sharepoint that retrieve the day, month and year and build the date together in power BI.

JamesCook's avatar
JamesCook
Regular Visitor
9 years ago

Hi Fyouri,

 

I checked again and have made an update to step 3, the datatype on the new column should have been datetime, not date.

 

Proof it works on my side is that the original column contains unique values (I set this on the sharepoint list) However when imported, we get duplicates on dates where UTC+1 kicks in in UK late March. Then, when we return to UTC, we get a missing day. The new column contains no duplicates or missing columns enabling it to create a many to one relationship with other tables in the model.

 

Give it a try. I'd be interested to know if it works for you.