Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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
Hi,
I need installer file of Power BI Desktop version 2.5.1 .
Can you please send this installer file to me .
Thanks
Santan
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.