Forum Discussion

Frixel's avatar
Frixel
Icon for Post Prodigy rankPost Prodigy
5 years ago
Solved

Error date modified and date created

Hi All,   What could be the problem if I let Power Bi look at a folder in sharepoint and this error appears. These are all files that have been placed in the folder by power automate.  
Need Help
  • Frixel's avatar
    Frixel
    5 years ago

    I solved it by setting the "regional settings" of the file to 'English (united states)' in the settings of Power Bi.
    Then a refresh and choose the option date / time in the options of the column.

     

    I think that is very strange because the "Global" settings of Power Bi were also already on  'English (united states)'

     

    So it is resolved but i don`t understand it.

     

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

when you click on one of the Error links you should get more details.  Likely a format/locale mismatch.

Frixel's avatar
Frixel
Icon for Post Prodigy rankPost Prodigy
5 years ago

Hi lbendlin 

 

See the image below.

As you can see is the file created this morning (17-04-2021) today and when i click on the 'Error' then it says that it is from 16-04-2021.

Also with the file above it it is the same error.

 

Files that are createt in the afternoon don`t have the error.

So i think it is a time issue but how can i resolve this?

 

 

 

 

And this is the properties from the file in Onedrive.

 

So the diffetent is 1 day and 3hours 🙄

I don`t understand it.