Forum Discussion
Parse JSON from Web
Hi simonGIS ,
You could use "Json.Document" to replace "Csv.Document" and remove other extra codes in the "Source".
Here is the document for your reference.
https://community.powerbi.com/t5/Desktop/rest-api-json-issue-column-issue/td-p/556282Or you could import it with ODBC.
https://zappysys.com/blog/howto-import-json-rest-api-power-bi/
Hi simonGIS ,
You could use "Json.Document" to replace "Csv.Document" and remove other extra codes in the "Source".
Here is the document for your reference.
https://community.powerbi.com/t5/Desktop/rest-api-json-issue-column-issue/td-p/556282
Or you could import it with ODBC.
https://zappysys.com/blog/howto-import-json-rest-api-power-bi/
Thanks.
So, started fresh.
- Power Query Editor, new query
- Added JSON from URL
- Applied Steps, Changed Type, Open Advanced Editor
- Removed the Csv.Document( and 2nd param
- Changed to JSON type
- Drilled down into features
- Tried converting this to table
From here I have two nested properties that I need to flatten into a table, the attributes and geometry
End goal table:
| CITY_NAME | POP | POP_RANK | POP_CLASS | X | Y |
| London | 70000 | 3 | 700 - 900 | 12345.1 | 12345.2 |
| .. | .. | .. | .. | .. | .. |
What would be the next steps to attempt to flatten out the JSON to get the above desired table?