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.
When in Power Query (Get Data), you can double click on a column heading and then rename the column. If the column has a null value (eg the null string ""), then you cannot double click on the column to edit. Instead you must right click on the column and select rename. This is inconsistent with the way it otherwise works and I think it should be "fixed" so it works the same. Double click on an unnamed column should allow you to edit the column name.
I have provided a sample query that you can use to validate. This query will not allow you to double click on the first column.
Matt
// Table 2
let
Source = Web.Page(Web.Contents("http://www.abs.gov.au/ausstats/abs@.nsf/Lookup/by%20Subject/1301.0~2012~Main%20Features~Population%2...")),
Data2 = Source{2}[Data],
#"Changed Type" = Table.TransformColumnTypes(Data2,{{"Column1", type text}, {"Column2", type text}, {"Column3", type text}, {"Column4", type text}, {"Column5", type text}, {"Column6", type text}, {"Column7", type text}, {"Column8", type text}, {"Column9", type text}, {"Column10", type text}}),
#"Removed Top Rows" = Table.Skip(#"Changed Type",1),
#"Promoted Headers" = Table.PromoteHeaders(#"Removed Top Rows", [PromoteAllScalars=true]),
#"Changed Type1" = Table.TransformColumnTypes(#"Promoted Headers",{{"", type text}, {"NSW", type text}, {"Vic.", type text}, {"Qld", type text}, {"SA", type text}, {"WA", type text}, {"Tas.", type text}, {"NT", type text}, {"ACT", type text}, {"Aust.(c)", type text}}),
#"Removed Bottom Rows" = Table.RemoveLastN(#"Changed Type1",4),
#"Removed Top Rows1" = Table.Skip(#"Removed Bottom Rows",1)
in
#"Removed Top Rows1"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.