Reply
Frequent Visitor
Posts: 2
Registered: ‎10-24-2017
Accepted Solution

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": [
                "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!


Accepted Solutions
Moderator
Posts: 9,487
Registered: ‎03-06-2016

Re: HTTP request

[ Edited ]

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 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Attachment

All Replies
Moderator
Posts: 9,487
Registered: ‎03-06-2016

Re: HTTP request

[ Edited ]

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 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Attachment
Highlighted
New Member
Posts: 1
Registered: ‎12-06-2017

Re: HTTP request

Hi,

I need installer file  of Power  BI Desktop version 2.5.1 .

 

Can you please send this installer file  to me .

 

Thanks

Santan