Forum Discussion

elmer's avatar
elmer
Helper I
6 years ago
Solved

Sharepoint data issue

Hi to all, I experience some issue with the date trying to import some data from a sharepoint list. This is the situation: I've created a report in power bi that used the data of a simple sharepoin...
Need Help
sturlaws's avatar
sturlaws
Resident Rockstar
6 years ago

Hi elmer ,

 

there are quite a few automatically updated date fields in a sharepoint list. Are you sure you are using the correct date field?

 

Cheers,
Sturla

  • elmer's avatar
    elmer
    Helper I
    6 years ago

    hi sturlaws 

    Thanks for your reply!

    I'm using the generic data field (the one that requires a manual insertion from a calendar) not a field that was automatically filled out by the system (like date of creation, etc...).

    • sturlaws's avatar
      sturlaws
      Resident Rockstar
      6 years ago

      I am not able to reproduce this behaviour when importing data from a sharepoint online list.

      Could you post some screenshots of what your data looks like, both in sharepoint and in power query?

      • elmer's avatar
        elmer
        Helper I
        6 years ago

        Hi sturlaws ,

         

        here's some screeshot (I've got the italian version). In the sharepoint list the date is correct (I've tried the "automatically fill current date" option and it works), but in power bi it adds 1 day.

         

        .