This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowThe Fabric community is upgrading! Read all of the details including the timeline and what you can expect. Learn more
We are not able to convert JSON format data in transform data. after converting to JSON we are getting no columns were found. like below screenshot.
| {"v":{"f":[{"v":"95FF-2EF5-5EA1"},{"v":"Cloud Storage"}]}} |
@saiprathapdp
> Please Following Step :
1> Right click on cloumn then reffer Screen Shot
after select your needed column press OK end get your output.THANK YOU!!
I tried this step, expand is not working because there is no data.
@saiprathapdp Please try below M code. i hope this helps you! Thank You!!
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45Wqo5RKotRsgJSaUAqGsqNUbI0dXPTNXJ1M9U1dXU0jFGq1YFLOefkl6YoBJfkFyWmpwJlYmtrlWJjAQ==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [JSN = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"JSN", type text}}),
#"Parsed JSON" = Table.TransformColumns(#"Changed Type",{},Json.Document),
#"Expanded JSN" = Table.ExpandRecordColumn(#"Parsed JSON", "JSN", {"v"}, {"JSN.v"}),
#"Expanded JSN.v" = Table.ExpandRecordColumn(#"Expanded JSN", "JSN.v", {"f"}, {"JSN.v.f"}),
#"Expanded JSN.v.f" = Table.ExpandListColumn(#"Expanded JSN.v", "JSN.v.f"),
#"Expanded JSN.v.f1" = Table.ExpandRecordColumn(#"Expanded JSN.v.f", "JSN.v.f", {"v"}, {"JSN.v.f.v"})
in
#"Expanded JSN.v.f1"
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.