How to change table name of dataset through power bi api ..?

[Shlokyy]

I have power bi report that is already published also i have embedded report in my react app, in my power bi report i found group id that is workspace  and  inside this i have created dataset like name is ReportOne my report is ceated, now in my report i have two tables like tableOne and tableTwo that will be the name of tables now i show the the report through my react app my dashboard show the data of tableOne now i want to change the table name using power bi Apis so whenever i want change tableName dashbaord will update with getting data from tableTwo whenevr i want to change the table name i again hit apis and change table name and my data will reflect on ui...!!

Can anyone tell me how i can acheive this complete process ...?

[Anonymous]

Hi @Shlokyy ,

Called using GET request:

https://api.powerbi.com/v1.0/myorg/groups/{group_id}/datasets/{dataset_id}/tables/{table_name}

Where group_id is the ID of the workspace group, dataset_id is the ID of the dataset, and table_name is the name of the table before the change.

In the obtained table metadata, modify the value of the {table_name} field to the new table name.

Called using PATCH request:

https://api.powerbi.com/v1.0/myorg/groups/{group_id}/datasets/{dataset_id}/tables/{table_name}.

Include updated table metadata in the request body.

Please note that you need to provide valid authentication and permissions to perform these operations.

After successfully changing the table name, refresh the dataset and reload the report in the react app and the report should change.

For more on the REST API, please see:

Power BI REST API: Step-by-step Guide to Use It | Coupler.io Blog

Datasets - Get Dataset In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn

Datasets - Update Dataset In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn

If you have any further questions please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[Shlokyy]

cuurelty in situation where  i have create a power bi dashboard to show data, and then i published the the report, now in react i have three button entityOne, entityTwo, entityThree when i click on entityOne there data will show on dashboard, when i click on entityTwo there data will show on dashboard similialry for third button, also note that i have only one report id so that dashboard is same i just want to change data only, can you please help me out for this