Forum Discussion
How to decode JSON data that I retrieved via API
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
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
3 Replies
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
LGTM
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
