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".
Hello lbendlin ,
Thanks for your quick response to this topic.
I am confused with it, where am I applying the transformation steps in Excel or in power query in power bi dataset where the data is coming from?
Thanks,
in Excel Power Query.
My power query is not coming up in Excel? It is greyed out.
I did the following steps:
File>Options>Add-ins>Manage>COM Add-ins>Go>Check Power Pivot for Excel
Still power query is not coming up?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".