Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Double Click on Blank Column to Rename doesn't work

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"

Status: Accepted
Comments
v-haibl-msft
Employee

@MattAllington

 

I can repro the same issue as you. I’ve reported it internally to Power BI Team: CRI 47294522
I’ll post here once I get any update about it.

 

Best Regards,
Herbert

Vicky_Song
Impactful Individual
Status changed to: Accepted
 
v-haibl-msft
Employee

@MattAllington

 

The fix will be available in the November release of PBI Desktop.

 

Best Regards,
Herbert