Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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?
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
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
User | Count |
---|---|
8 | |
7 | |
2 | |
2 | |
2 |
User | Count |
---|---|
6 | |
5 | |
4 | |
4 | |
4 |