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 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!

Need Help
Tutorial Requests

2 Replies

  • 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