Wrong date from SharePoint-List

[Anonymous]

Hi Community

I have a problem with a report. I create a report from a sharepoint list. In the SP-List there is a date column "abgeschlossen am":

This column has the format "date". Unfortunately in my powerbi report it shows me the wrong date:

I also check the power query, and also there is the wrong date:

Can you give me a hint, what the problem might be here? Thanks for your help.

[Traconis]

I can confirm this problem still exist in Excel 365. All dates taken from SharePoint list via Power Query are shifted by 1 day...

[DavidVK]

Hello all

I am experiencing the same issue:

SharePoint list:

In Power BI

I have tried to adjust timezone, did not help.

I have tried to rebuild the PowerBI from scratch, did not help.

And there is a constant mismatch of 1 day.

[Mariusz]

Hi @Anonymous 

Silly sugestion, but have you try to Refresh?

Regards,
Mariusz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[Anonymous]

I've just seen that probably all the date fields are "shifted" by one day:

SP:

Powerbi:

Is it maybe some kind of timezone settings problem? I've check in SP, there is the right timesettings.

[v-shex-msft]

HI @Anonymous ,

I think it may related to 'UTC - Local' datetime convert or daylight saving time. 

Convert UTC to Local Time with Daylight Savings Support in Power BI

Please understand that this link is provided with no warranties or guarantees of content changes, and confers no rights.

Regards,

Xiaoxin Sheng

[Anonymous]

 Hi @v-shex-msft 

Thanks for your post. I saw this information on top of this article:

Update:  The Power BI service was recently updated such that DateTimeZone.ToLocal() now uses the client time zone which means the solution below is no longer needed to resolve the problem discussed.

The strange thing is that my client timezone is the same like in sharepoint.

[Anonymous]

Of course, i also try to delete the date in the SP-column and add the date "01.05.2019" again.

And i also tried to create a new Pbi-report as well. Same problem...