让我为那些想要在不编写 Power Query 的情况下使用 Power BI 用户界面(桌面/Web)执行此操作的人分享分步指南。
-
打开 Power BI 桌面
-
Get Data → More ...→ 选择JSON从列表中单击“连接”(您还可以使用 WEB API 或其他为您提供 JSON 数据的来源)
-
选择 JSON 文件并将其打开。
-
在数据面板中,您可以看到 Family|List。点击List添加导航步骤的链接。
-
在“变换”选项卡中,单击To Table然后从对话框中单击OK.
-
From the header of "Column1", click on Expand columns button to expand columns and from the menu, uncheck Use original column name as prefix and check the columns that you want and click on OK.
-
You will see the columns and data in table format. You can change data type of columns by click on data type button .
最后你会得到这样的东西:
最后,如果您想查看生成的查询,请单击高级编辑器按钮并查看代码:
let
Source = Json.Document(File.Contents("C:\Users\rag\Desktop\data.json")),
Family = Source[Family],
#"Converted to Table" = Table.FromList(Family, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"Father", "Age", "Mother", "MAge"}, {"Father", "Age", "Mother", "MAge"}),
#"Changed Type" = Table.TransformColumnTypes(#"Expanded Column1",{{"Age", type number}, {"MAge", type number}})
in
#"Changed Type"
更多信息:
- Power BI Desktop 入门 https://learn.microsoft.com/en-us/power-bi/fundamentals/desktop-getting-started?WT.mc_id=DT-MVP-5003235
- 在 Power BI Desktop 中塑造和组合数据 https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data?WT.mc_id=DT-MVP-5003235
- 在 Power BI Desktop 中执行常见查询任务 https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-common-query-tasks?WT.mc_id=DT-MVP-5003235