Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Using API for parallel update of dataset

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 connec...
Need Help
Tutorial Requests
Jayendran's avatar
Jayendran
Solution Sage
7 years ago

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's avatar
    Jayendran
    Solution Sage
    6 years ago

    Hi Anonymous 

     

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