Forum Discussion

stokidez's avatar
stokidez
Icon for Helper III rankHelper III
5 years ago

Date discrepancy between SharePoint List and PowerBI

Hi folks,

 

I have a SharePoint list which is connected to my PowerBI dashboard. A number of of the dates (not all) within the same column are displaying in PowerBI incorrectly. Please can someone advise? I've read other posts on this matter - the Regional Settings of my SharePoint site are set correctly (UK). The field in question is set as a date in SharePoint and in PowerBI. I've seen that some people have adopted a workaround of a custom field which adds a day to the date field causing them issue - this wouldn't work in this instance because some of the dates are actually correct.

 

In the attached screenshot, the SP List is on the left hand side, and Power BI Data view on the right. The blue lines indicate where there is a discpreancy, the black lines are examples where the dates match.

 

Any help would be much appreciated!

 

Need Help

1 Reply

  • selimovd's avatar
    selimovd
    Icon for Most Valuable Professional rankMost Valuable Professional
    5 years ago

    Hey stokidez ,

     

    for me it looks like one of the sources is in the wrong time zone.

    You can change that easily with Power Query within Power BI. Check the following video, it will explain it in Excel, but you can do exactly the same in Power Query within Power BI:

    Changing Time Zones in Power Query - YouTube

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis