cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
flennon
Frequent Visitor

Rest API time too slow

I've created a test push dataset in power BI. Using Postman, the time it takes to complete the request is roughly 1 second. It varies slightly but seems to be consistently 1 second. I've tried it in both PowerShell and Java, using Java.net's httpsURLconnection Class, but they are not any faster. This is too slow for my purposes. Could anyone advise on what I can do?

image.png

2 REPLIES 2
Highlighted
Microsoft
Microsoft

Re: Rest API time too slow

I don't think there is a better way to speed up the REST call.

Things that I can think out is when deploying the Power BI, make sure you have the nearest storage selected.

Read more here:

For tenant location part.

 

Regards,

Michael

flennon
Frequent Visitor

Re: Rest API time too slow

This was my first experience with REST APIs, I didn't realise that you could send multiple rows per POST Request. Once I got the syntax right to send multiple rows, I had no need for multiple POST Requests per second. 

 

According to this microsoft link , Power BI's REST API is limited to120 POST rows requests per minute per dataset

Helpful resources

Announcements
‘Better Together’ T-Shirt Contest – Winner Announced!

‘Better Together’ T-Shirt Contest – Winner Announced!

And the winner is...

Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.