Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
21 | |
2 | |
2 | |
2 | |
2 |