Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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!
User | Count |
---|---|
88 | |
88 | |
73 | |
67 | |
58 |
User | Count |
---|---|
136 | |
110 | |
91 | |
84 | |
69 |