Forum Discussion

Mohan1's avatar
Mohan1
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

How to rename table name programatically

I got a secnario to work,I need to rename the table in a particular data set which needs to be done programatically something like using APIs. is it possible?   Please let me know if you need more ...
ankitpatira's avatar
ankitpatira
Icon for Community Champion rankCommunity Champion
10 years ago

Mohan1 Power BI has set of APIs that you can use. Check out this article on update table schema API. I am not sure if it will let you update table name but you can try it out. Also this one has table_name request.

  • Mohan1's avatar
    Mohan1
    Icon for Microsoft Employee rankMicrosoft Employee
    10 years ago

    ankitpatira Thanks for suggesting Update table schema API, I tried this API its only allowing me to change the schema of a table not the table name. I tried in Power BI Apiary.

    • arify's avatar
      arify
      Icon for Microsoft Employee rankMicrosoft Employee
      10 years ago

      Maybe you can have a Record value (named 'environment' ?) and it will contain your tables? You can easily use record's keys as table names.