HTTP request

[CarCrazyBen]

I am using Power BI Desktop version 2.5.1 on Windows 10.  I have successfully used a connected to an HTTP request to retrieve JSON data from a CouchDB instance.

In Postman (for example) the output is JSON-formatted with the Keys and Values like:
{    "total_rows": 102,
    "offset": 0,
    "rows": [
        { "id": "476ea2280f01cee4fca3b6f361346502e7ecdaf5-bd_RLeo@dcpmidstream.com_2017-10-11T19:38:03.574Z",
            "key": null,
            "value": [
                "JohnDoe@someemail.com",
                "2017-10-11T14:38:03-05:00",
                null]
        },

etc, etc for a total of 102 records.  When I bring this into Power BI Query Editor it seems the data comes in "reduced" or something.  All I see is a tabular display like this:

    a row labeled total_rows and the vlaue 102

    a row labeled offset        and the value 0

    a row labeled rows          and the value "List", which is a hyperlink to my 102 Records.

How to I display the actual text associated with these records, the same way Fauxton or Postman displays it?

The data returned is actually JSON. 

Thank you!

[santansre]

Hi,

I need installer file  of Power  BI Desktop version 2.5.1 .

Can you please send this installer file  to me .

Thanks

Santan

[v-qiuyu-msft · Accepted solution]

Hi @CarCrazyBen,

You can follow the steps here to parse data: Multi-Dimensional Json file to Table . 

Also you can take a look at attached pbix file, which is more simple.  

Update: Please remove sensitive data eg: acocunt before post in the forum. 

Best Regards,
Qiuyun Yu