Forum Discussion

pthapa's avatar
pthapa
Post Patron
2 years ago
Solved

How to remove the table name in column headers in Excel?

Hello all, Excel sheet is connected to power bi dataset and when the table is loaded, it adds the table name on suffix and the column name. How can we not have the table name on the column headers? ...
Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago

    Select your semantic model and add it to a table

     

    Next, create a new query "from table"

    add the step into the query

     

    let
    Source = Excel.CurrentWorkbook(){[Name="Table_ExternalData_1"]}[Content],
    Res = Table.TransformColumnNames(Source,each if Text.End(_,1)= "]" then let p=Text.PositionOf(_,"[") in Text.Range(_,p+1,Text.Length(_)-p-2) else _ )
in
    Res

     

    Click "Close and Load".

lbendlin's avatar
lbendlin
Super User
2 years ago

Table.TransformColumnNames(Source,each if Text.End(_,1)= "]" then let p=Text.PositionOf(_,"[") in Text.Range(_,p+1,Text.Length(_)-p-2) else _ )