Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
Happy to help!
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
Happy to help!