Forum Discussion

SamGibbs1's avatar
SamGibbs1
Frequent Visitor
4 years ago

Incorrect dates in power bi

Hi all, This has simialr threads, but none asking the exact same question. I have a date in power apps (1 June 2021) that is passed to SharePoint as 1 June 2021, but when it is pulled into power BI ...
Need Help
SamGibbs1's avatar
SamGibbs1
Frequent Visitor
4 years ago

Ah the issue was the system time - however as it was set to UTC +0 (as I am in London) I missed the box that automatically adjusted to BST.

As a work around I have added a couple of hours to the date time before doing further processing.

  • pkumarsharma's avatar
    pkumarsharma
    Regular Visitor
    3 years ago

    Hi

    I have the same issue, How did you fix, Could you please provide details.

     

    • SamGibbs1's avatar
      SamGibbs1
      Frequent Visitor
      3 years ago

      It was a while ago, but I think I added 2 hours to the column so that it had the correct date.