Convert text to date/time from sharepoint list

Hi all

I want to implement PBI functions to our companies SP site. I went trough some tutorials. 

Importing the SP-list to PBI Desktop works, but it reads everything as text. Unfortunately trying to convert the "Created" column to Date/time creates an error

Since the "Created" column is an SP default, it has no special formatting. The conversion doesn't work for "Modified" column as well.

Looking forward to get an answer how to convert this.

Thanks, Philip