Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
When I click on Refresh after adding in updated data, ie has extra 2 columns, this is not included in the table.
In the table currently has 7 columns, but in my source has 11 columns. How do I ensure the whole of the source worksheet is including any extra columns?
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"App Group name", type text}, {"App Group name(T)", type text}, {"User", type text}, {"Description", type text}, {"User type(T)", type text}, {"Value", Int64.Type}}),
#"Grouped Rows" = Table.Group(#"Changed Type", {"App Group name"}, {{"Description", each Text.Combine([Description], ", ")}}),
#"Split Column by Delimiter" = Table.SplitColumn(#"Grouped Rows", "Description", Splitter.SplitTextByDelimiter(",", QuoteStyle.Csv), {"Description.1", "Description.2", "Description.3", "Description.4", "Description.5", "Description.6", "Description.7"}),
#"Changed Type1" = Table.TransformColumnTypes(#"Split Column by Delimiter",{{"Description.1", type text}, {"Description.2", type text}, {"Description.3", type text}, {"Description.4", type text}, {"Description.5", type text}, {"Description.6", type text}, {"Description.7", type text}})
in
Thanks
Michelle
You have used "group by" in the data cleansing process. The question is, how will their placement in the grouping change when new columns are added?
In 3rd step you grouped table that affectes on the result and you can't see the extra columns because they didn't use in "group by" step.
Great so what is the solution?
User | Count |
---|---|
77 | |
74 | |
60 | |
60 | |
46 |
User | Count |
---|---|
109 | |
95 | |
86 | |
79 | |
61 |