I have a URL that points to a sample server that returns JSON records:

[https://sampleserver6.arcgisonline.com/arcgis/rest/services/LocalGovernment/Events/MapServer/0/query?where=1%3D1&outFields=\*&f=pjson](https://sampleserver6.arcgisonline.com/arcgis/rest/services/LocalGovernment/Events/MapServer/0/query?where=1%3D1&outFields=*&f=pjson)

I want to use the JSON records in Excel as a **table**.

---

I've attempted to do this by connecting to the URL via Excel **Power Query**:

[![enter image description here](https://i.stack.imgur.com/Ht9tw.png)](https://i.stack.imgur.com/Ht9tw.png)

However, it seems like Power Query is treating the data as CSV records, not as JSON records.

[![enter image description here](https://i.stack.imgur.com/hpkMH.png)](https://i.stack.imgur.com/hpkMH.png)

So the data is not coming into Power Query as a proper table.

[![enter image description here](https://i.stack.imgur.com/WiIcM.png)](https://i.stack.imgur.com/WiIcM.png)

---

How can I get Power Query to select the JSON records as a table in Excel?