Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
Anonymous
Not applicable

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!

2 REPLIES 2
Jayendran
Solution Sage
Solution Sage

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 

Hi @Anonymous 

 

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

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.