Power BI desktop renaming table or column in DAX: where is the code ?

[philthegaps]

Hi all

I always wondered where I can find the code related to the renaming of a table or column in DAX, in Power BI Desktop. No code is created in Power Query, and I cannot see any code in DAX. So how can we have the original name if nothing is traced ?

Other topic: when I use Tabular Editor V2, I can change the names of the table/column inside the Tool (via the contextual menu), and save : the PowerBI desktop shows the changes and the names are changed accordingly.

But as soon as I refresh the PowerBI desktop a rollback is done and all my changes disappear.

If you have some clue, don't hesitate
Regards

[v-yifanw-msft]

Hi @philthegaps ,
You can try looking in the Advanced Editor in the Power Query Editor to find steps on renaming.

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[philthegaps]

Hi Ada

Thank you for your answer.

A I said, the renaming has been made on the DAX. Here after, column "b" has been renamed in "cc" tablze "Sheet1" has been rennamed in "Sheet2"  but you can see that there is no "Table.RenameColumns" instructions in PowerQuery.

Here is the code:

let
    Source = Excel.Workbook(File.Contents("Book1.xlsx"), null, true),
    Sheet1_Sheet = Source{[Item="Sheet1",Kind="Sheet"]}[Data],
    #"Promoted Headers" = Table.PromoteHeaders(Sheet1_Sheet, [PromoteAllScalars=true]),
    #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"a", Int64.Type}, {"b", Int64.Type}})
in
    #"Changed Type"

Best regards

[Daniel29195]

@philthegaps 

i understand that you want the tracing of renaming columns  ?  like what was the name of the column before you change it ? it that correct ? 

if the changes are made in power bi, then you should have in power query the rename column steps . 

[philthegaps]

Hi Daniel

As I said, I can see nothing in Power Query.