Forum Discussion

nick9one1's avatar
nick9one1
Helper III
3 years ago
Solved

SharePoint date changes when imported

I have a SharePoint document library that has a 'Call Date' column and four files. When I connect to this with PowerBi, it imports the dates but they are wrong. One matches, but the other three are o...
Need Help
  • nick9one1's avatar
    nick9one1
    3 years ago

    I found out how to fix it. 

    In advanced editor change the api version to 14. 

     

    In source settings change implementation to 2.0 

     

    Then in the navigatgion step settings choose your list/library

    all working. 

     

     

     

  • nick9one1's avatar
    nick9one1
    Helper III
    3 years ago

    no it isnt. Three of the dates are incorrect. One is correct. 
    A timezone mismatch would affect all dates.