Forum Discussion
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? ...
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 ResClick "Close and Load".
For those wondering where to paste the code, click Advanced Editor.