topic Re: Using API for parallel update of dataset in Developer

Using API for parallel update of dataset

Anonymous — Wed, 14 Aug 2019 18:16:03 GMT

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!

Re: Using API for parallel update of dataset

Jayendran — Thu, 15 Aug 2019 05:21:10 GMT

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

Re: Using API for parallel update of dataset

Jayendran — Thu, 05 Sep 2019 06:24:27 GMT

Hi @Anonymous

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