I have a performance issue regarding one of the API endpoint.
I'm working on a Power BI report to analyse the content of a Power BI tenant (workspace, report, dataset, datasource...)
I'm getting datasources details using the GetDatasourcesAsAdmin endpoint.
It's working fine but it takes 15/20 sec to execute while all other endpoints call take 1-2 sec on the same tenant.
For example, the similar GetDatasetsAsAdmin takes 1 sec to execute.
The tenant contains around 120 workspaces/groups and about 400 datasets.
It takes 2 hours to get all the datasources info...
Any ideas why it's taking so long?
Could you please send me the ID as the snapshot shows? Maybe I can find something from the log database.
BTW, do you have a premium capacity?
thanks for your message!
The Power BI tenant is not under Premium capacity, we only use Professional licences.
I relaunch the API this morning, the request id is : dc7085e7-2da1-4de1-9330-53488369ff5f.
Let me know if you find something in the log database.
Here is the snapshots :
GetDatasourcesAsAdmin API callResponse headers
Thanks again for your help
No errors can be found in the Log database. Actually, the log is quite short.
1. I saw there are two headers. What are they? Only the token is needed.
2. How many data sources in your test? What are they if possible to provide?
I will test again.
If you have a Pro license, I would suggest you file a support ticket here.
1. There's one header for the request and one header for the response
2. Only 2 datasources are returned in my test
I filed a ticket with the support team. To me it's clearly a back-end issue that requires intervention from the development team, not the kind of people easy to reach though