Excel can not Convert JSON data to Table in Excel properly

%3CLINGO-SUB%20id%3D%22lingo-sub-2365061%22%20slang%3D%22en-US%22%3EExcel%20can%20not%20Convert%20JSON%20data%20to%20Table%20in%20Excel%20properly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2365061%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20tried%20to%20convert%20JSON%20data%20from%20a%20web%20link%20related%20to%20COVID-19%20using%20power%20query%20but%20was%20not%20able%20to%20do%20it.%20I%20do%20not%20know%20if%20the%20issue%20from%20the%20source%20or%20from%20my%20ability%20to%20convert%20the%20data.%3C%2FP%3E%3CP%3EYour%20support%20is%20highly%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELink%20to%20the%20data%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fservices6.arcgis.com%2FbKYAIlQgwHslVRaK%2Farcgis%2Frest%2Fservices%2FCumulative_Date_Grouped_ViewLayer%2FFeatureServer%2F0%2Fquery%3Fwhere%3D1%253D1%26amp%3BoutFields%3D*%26amp%3BoutSR%3D4326%26amp%3Bf%3Djson%26nbsp%3B%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fservices6.arcgis.com%2FbKYAIlQgwHslVRaK%2Farcgis%2Frest%2Fservices%2FCumulative_Date_Grouped_ViewLayer%2FFeatureServer%2F0%2Fquery%3Fwhere%3D1%253D1%26amp%3BoutFields%3D*%26amp%3BoutSR%3D4326%26amp%3Bf%3Djson%26nbsp%3B%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi All,

 

I have tried to convert JSON data from a web link related to COVID-19 using power query but was not able to do it. I do not know if the issue from the source or from my ability to convert the data.

Your support is highly appreciated.

 

Link to the data:

https://services6.arcgis.com/bKYAIlQgwHslVRaK/arcgis/rest/services/Cumulative_Date_Grouped_ViewLayer...

 

0 Replies