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 have an cdr(Call detail record) web array that is exported through a link:
{
"Origem":"1031",
"Destino":"984249909",
"Data":"2017-03-07 09:35:04",
"Audio":"2017/03/07/09-35-05-1031-984249909-1488890104-234-000000c5",
"Status":"1",
"TempoChamada":"00:04:41",
"TempoAtendimento":"00:04:31",
"HangupCause":"16"
}
And need to make a table out of it and have no idea how to nor can i find anything online to help me
let
Source = "{
""Origem"":""1031"",
""Destino"":""984249909"",
""Data"":""2017-03-07 09:35:04"",
""Audio"":""2017/03/07/09-35-05-1031-984249909-1488890104-234-000000c5"",
""Status"":""1"",
""TempoChamada"":""00:04:41"",
""TempoAtendimento"":""00:04:31"",
""HangupCause"":""16""
}",
#"Parsed JSON" = Json.Document(Source),
#"Converted to Table" = Record.ToTable(#"Parsed JSON"),
#"Pivoted Column" = Table.Pivot(#"Converted to Table", List.Distinct(#"Converted to Table"[Name]), "Name", "Value")
in
#"Pivoted Column"
How to use this code: Create a new Blank Query. Click on "Advanced Editor". Replace the code in the window with the code provided here. Click "Done".
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.
User | Count |
---|---|
106 | |
98 | |
80 | |
67 | |
63 |
User | Count |
---|---|
145 | |
111 | |
104 | |
84 | |
64 |