How to decode JSON data that I retrieved via API

[dc7669]

Hi,

I tried to retrieve data via API into PowerBI Desktop. 

The API request itself is good and brought back data. 

But, below is the screen I encounter.  

How can this data be decoded. 

I would like a table with columns of 

ID_BURN_PERMIT, COUNTY, AREA,...etc 

Each record, everything within {}, shall be a row. 

Any idea? 

Should I specify in the API request to let PowerBI knows that the returned result is JSON data? 

Or

SHould I use "Extract Table Using Example"?   I tried that but I could not get it to work.

Thanks.

Dchan

[dc7669]

Hi Deku,

Thanks for the reply...... I may have figured it out......

In Web link, I added application  application/json like below

Then, when the data is returned, I got the data without them being in a table.

Then, I convert the data into Table.

Then, all the data are in Column 1, row 1.

Then, I right click on column1, then, select Transform, and then JSON. 

I got a List.

Then, I right click on "Expand" icon and select "Expand to New Rows".  I got this: 

Then, I right click on the "Expand" icon to show all columns in a table!  

This is the Advanced Editor screen for me for the above steps.  

When I go back to the "Recent Resources", I got this:

The "Open File As" option was NOT available before. 

So, I guess I got it.  But, I wonder if this is the best way as it did involve a few steps. 

Thanks.

Dc7669

[Deku]

LGTM

[Deku · Accepted solution]

Have a look at how the powerquery JSON connector decodes JSON files. It should allow you to easily generate a tabular format

Would avoid extract table from example