Forum Discussion
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!
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
2 Replies
- v-qiuyu-msftCommunity Support
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 - santansreNew Member
Hi,
I need installer file of Power BI Desktop version 2.5.1 .
Can you please send this installer file to me .
Thanks
Santan