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". 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.

Need Help

7 Replies

  • Mariusz's avatar
    Mariusz
    Community Champion
    7 years ago

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

      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...

    • 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.

  • DavidVK's avatar
    DavidVK
    Frequent Visitor
    4 years ago

    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.

  • Traconis's avatar
    Traconis
    New Member
    3 years ago

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