json - 在 Power BI 中解析 .json 列

Question

我想通过 Power BI 解析 .json 列。我直接从服务器导入了数据，并且数据中有一个 .json 列以及其他列。有没有办法解析这个json列？

例子:

       Key      IDNumber    Module      JsonResult  
       012      200         Dine        {"CategoryType":"dining","City":"mumbai"',"Location":"all"} 
       97       303         Fly         {"JourneyType":"Return","Origin":"Mumbai (BOM)","Destination":"Chennai (MAA)","DepartureDate":"20-Oct-2016","ReturnDate":"21-Oct-2016","FlyAdult":"1","FlyChildren":"0","FlyInfant":"0","PromoCode":""} 
       276      6303        Stay        {"Destination":"Clarion Chennai","CheckInDate":"14-Oct-2016","CheckOutDate":"15-Oct-2016","Rooms":"1","NoOfPax":"2","NoOfAdult":"2","NoOfChildren":"0"}

我希望保留其他列并获得简化的解析列。

Answer 1

像这样使用 Json.Document 函数

let
    ...
    your_table=imported_the_data_directly_from_the_server,
    json=Table.AddColumn(your_table, "NewColName", each Json.Document([JsonResult]))
in
    json

然后使用 Table.ExpandRecordColumn 将记录扩展到表

或者点击这个按钮