Forum Discussion

Mattula's avatar
Mattula
Frequent Visitor
2 years ago

Sharepoint List to Power Bi Date Error

Hi Everyone    I have an error receiving data from a sharepoint list into my PowerBi report. Which I do not understand what is happening.    My sharepoint receives information from a form, includ...
Dataflow
General Comment
Need Help
Mattula's avatar
Mattula
Frequent Visitor
2 years ago

I have checked and my sharepoint list is set to UTC. How is this issue occurring and how do I fix it? 

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    treat your timestamps as DateTimeZone type in Power Query

    • Mattula's avatar
      Mattula
      Frequent Visitor
      2 years ago

      I have done this but it hasn't resolved the issue. The date from sharepoint is still changing in PowerBi