TMSL request alter column description

Question

I am a nub in TMSL and I need your help.

I am trying to add a description to the column in Poweer BI Services with a command:
{
"alter ": {
"object": {
"database": "dataset_test",
"table": "005_SHIP_TO_LOCATIONS",
"column":"CREATION_DATE"
},
"column": {
"name": "CREATION_DATE",
"description":"This is the new description"
}
}
}

The error I get is:

Unrecognized command: alter . Check path '['alter ']', line 2, position 13.

Could you help me to make it work?

This is Power BI Premium and I TMSL works for table name modification, but I can't figure out how to change the column description.

Answer 1

Hi @Kazanskyi, Oleg ,

As said alter-command-tmsl in this documentation.

Alter command can be used to alter object like database, connection, table, partition and role, but it could not be used for only one of the column description. To do that, you might need to specify all the columns that existed in the table.

I'd suggest that you may use DAX Editor to do the changes.

Regards，

Zoe

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.