- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Power BI desktop renaming table or column in DAX: where is the code ?
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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 .
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
01-20-2024 06:58 PM | |||
12-28-2023 02:28 AM | |||
06-05-2023 05:09 AM | |||
09-18-2023 07:26 AM | |||
06-27-2023 07:29 AM |