Forum Discussion

Post 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
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.

mahoneypat

Microsoft Employee

5 years ago

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

Frixel

Post Prodigy

5 years ago

It doesn`t matter when i changed to localy type, the error apears.