Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! 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.
Join Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.