Forum Discussion

CarCrazyBen's avatar
CarCrazyBen
Regular Visitor
8 years ago
Solved

HTTP request

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": [
                "[email protected]",
                "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!

2 Replies