Opendata import problem

[Anonymous]

Hello PBI experts,

I have been using this opendata dataset for months : https://opendata.arcgis.com/datasets/814f8e1550db4852b2c0a79f23c66f9c_0.geojson 

But since a few days, I do have a problem : "OLE DB or ODBC error: [DataFormat.Error]".

It seems that after navigation-> convert to table-> column1 developped the column "date_fin" can't be changed from text to date time format.

I have tried to find where the problem comes from : no "strange" row data, no header used to do the formatting... I am still not able to change the format from text to date time...

Is there any way to make sure the text is matching date format before formatting ? Could you please help me solve this format trouble ?

Regards,

Antoine

[ibarrau · Accepted solution]

Hi. Did you try to run that URL in browser? it fails. I think that the URL no longer exists. I have checked that if you change the text of opendata to hub it download the geojson.

Try this url instead:

https://hub.arcgis.com/datasets/814f8e1550db4852b2c0a79f23c66f9c_0.geojson 

Hope this helps 

[Anonymous]

@ibarrau It works ! Thanks for your help.