PowerQuery - Table view - Data Mismatch

[Slavi]

Hello PBI community!

I hope you can help with a bizarre issue I am experiencing.

I am pulling data into my Power BI desktop report file from a SharePoint list, making some simple manipulation steps in PowerQuery, visualising and then publishing to the Power BI Server. 

The problem I am facing is related to mismatch of data between PowerQuery and the Table view in the Power BI desktop. 

Basically, this happens in an ad-hoc basis, when the report is published to the server, one particular date column shifts some of the months with one day back, for no apparent reason. When I download the report from the server and take a look at the data in PowerQuery it looks correct, but at the same time the data is different in the Table view.

I am not creating any calculated columns, I am just parsing the text-date column coming from the SharePoint list into a date format. And the data is being shifter for only some of the months not all of them.

Has anyone experienced something like this and do you guys have any idea why this might be happening?

Thank you!

[KNP · Accepted solution]

I think I've had something similar happen.

In my case it was related to time zone, daylight savings and SharePoint settings.

Check the settings in SharePoint, depending on your SharePoint...

Settings icon >> Site information >> View all site settings >> Regional settings

The other thing would be how you're doing the conversion in PQ, if you use the locale option, it may solve the problem.

Can you post the code for the steps relating to the date transformation?

[Slavi]

Hello KNP!

Indeed it was a problem associated with the time zone. 

A big thank you for your help!