Convert text to date/time from sharepoint list

[Anonymous]

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

[Anonymous]

Thanks. This worked. For beginners like myself, who didn't know what power query in PBI is, I add this PrtScn

[mh2587]

You are welcome ,In power query You can Extract data , Transform data and load data after final evaluation 

[mh2587 · Accepted solution]

Try it in power query