Unable to rename columns of a calculated duplicate table

[Mecka]

Hello all,

I'm new to Power BI and I am following the lessons provided by Microsoft to learn the basics on their learning portal.

Here is the link to the lesson where I met my issue, a sample dataset is provided for download on that page (Adventure Works DW 2020 M03.pbix):

https://learn.microsoft.com/en-us/training/modules/dax-power-bi-add-calculated-tables/1-introduction

I met a scenario where I have to duplicate a table: the table is successfully replicated on my end.
The next step advises to rename the columns of the duplicate table: this where I come accross an error message and I am unable to edit the header names.

The message states "Unexpected Error: Error Applying Changes"

Has this feature been discontinued?

I see that I can rename the headers of the original table but the duplicate table headers seem to be linked to the original table so they are not editable.

Thanks

[v-yueyunzh-msft · Accepted solution]

Hi , @Mecka 

Accoridng to your description, you use the dax "Ship Date = 'Date'" to duplicate a table in power BI Desktop.

And you want to update the column name in the new table .

I test it in my side , it works good without any error code:

According to my experience, using dax to copy a table actually generates a new table based on the modified table, which supports modifying the column names of this table.

If your problem persists, you can try to download the latest version of desktop to check if the problem still occurs.

In addition, we can also copy tables in Power Query:

Since I don't have credentials configured, I can't see the data here, you can test it on your side with an excel.

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

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

[avmashok]

You can do :
let us consider you are creating a user table using DAX from existing some transactional table e.g order

DAX:- the table name is _User
-----

_User = 
var _TB = SELECTCOLUMNS([order],"User Key",[UserKey])

//if you want to rename the _TB table, same approach

var _TB1 = SELECTCOLUMNS(_TB,"User Id",[User Key])

RETURN _TB1

[Mecka]

Thank you so much @v-yueyunzh-msft for suggesting this solution.

I have upgrading my Power Bi desktop client to latest version and I am now able to rename the columns

have a nice day 😀