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
8 years ago

You should just be able to edit the M code for the read from the SharePoint list and probably the first few lines of code without having to completely rewrite the query.

 

IIRC when I had to do this for another problem I started off a new query against the same List, changed the API to 14 and then expanded the data out until it was in the same structure as the original query. Then cut and paste the M code from the temporary query into the M code of the old query, probably adjust a few #stepname bits and off you go.

 

If I've misunderstood your problem, then please excuse my ramblings :-)

csabil's avatar
csabil
Advocate II
8 years ago

You understood right, I think. But with the different API, somehow some column names are also different, for example gets an extra "0" to the end, so I think at the end of the day, it will be easier to make it again step by step.

 

But this basic issue should be still solved, as this is just a workaround.