Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Wrong date from SharePoint-List

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". Un...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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's avatar
    Anonymous
    Not applicable
    7 years ago

     Hi Anonymous 

     

    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.