Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Opendata import problem

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

Need Help
  • ibarrau's avatar
    ibarrau
    6 years ago

    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 

2 Replies

  • ibarrau's avatar
    ibarrau
    Super User
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago

      ibarrau It works ! Thanks for your help.