March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe 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
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!
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
POST https://api.powerbi.com/v1.0/myorg/groups/{groupId}/datasets/{datasetId}/Default.UpdateDatasources
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!