Using API for parallel update of dataset

[Anonymous]

Hello everyone,

My company uses an enterprise database where there is a limit on the number of licenses that we can have connected at one time. Therefore, because our Power BI worksheet is connected to our database, and several tables use different queries to it, I'd like to build a program using the API to load the tables one at a time. Which method of the API allows me to do this, if it's even possible? I've been looking at the API and can't seem to figure it out.

Thank you!

[Jayendran]

Hi @Anonymous 

There is no such API to update the SQL Table. However you can update the datasource with the below 2 options

1. Update data source API

2. Update Parameter API

1. Update Data Source API

POST https://api.powerbi.com/v1.0/myorg/groups/{groupId}/datasets/{datasetId}/Default.UpdateDatasources

2. Update Parameters API

POST https://api.powerbi.com/v1.0/myorg/groups/{groupId}/datasets/{datasetId}/Default.UpdateParameters

Using this you can update the sql server and sql database 

[Jayendran]

Hi @Anonymous 

Do you have any update ? If my replay helps please accept it as answer/giving kudos which will help other community members