cancel
Showing results for 
Search instead for 
Did you mean: 
0

API Call takes too long

Hi,

 

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?

 

Thanks,

Nicolas

 

GetDatasourcesAsAdmin.png

 

 

 
Status: Delivered
Comments
Community Support Team

Hi @strawn,

 

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?

API-Call-takes-too-long

 

Best Regards,

Dale

Community Support Team
Status changed to: Needs Info
 
Visitor

Hi Dale,

 

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 :

 

api-1.pngGetDatasourcesAsAdmin API callapi-2.pngResponse headers 

Thanks again for your help Smiley Happy

 

Nicolas

Community Support Team

Hi Nicolas,

 

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.

create-ATicket

Best Regards,

Dale

 

Visitor

Hi Dale,

 

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 Smiley Wink

 

Thanks again for your help Smiley Happy

 

Nicolas

Community Support Team
Status changed to: Delivered