Forum Discussion
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.
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.
5 Replies
If you have a Changed Type step in your query, update that to convert those columns to Text first (instead of DateTime) to see what the values are to help troubleshoot. If that is successfull, right click and choose to date using locale to see if that successfully converts it.
Change Type Using Locale with Power Query • My Online Training Hub
Regards,
Pat
It doesn`t matter when i changed to localy type, the error apears.
even when i make it tekst then the error`s appears😂
when you click on one of the Error links you should get more details. Likely a format/locale mismatch.
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.
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.
