Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in BI by (17.6k points)
edited by

I want to parse a .json column through Power BI. I have imported the data directly from the server and have a .json column in the data along with other columns. Is there a way to parse this json column?

 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"}

I wish to retain the other columns and also get the simplified parsed columns.

 

1 Answer

0 votes
by (47.2k points)

Use Json.Document function in this way

let

    ...

    your_table=imported_the_data_directly_from_the_server,

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

in

    Json

Related questions

+10 votes
2 answers
asked May 30, 2019 in Java by tommas (1k points)
0 votes
1 answer
asked Oct 27, 2019 in Java by Shubham (3.9k points)
+2 votes
2 answers
0 votes
1 answer
asked Jul 9, 2019 in BI by Vaibhav Ameta (17.6k points)
0 votes
1 answer

31k questions

32.8k answers

501 comments

693 users

Browse Categories

...