Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
BenMackin
Helper I
Helper I

API Performance Issues

I am having a strange issue.

 

We have two servers, one with Windows Server 2016 and the other with Windows Server 2019. Both servers are running the latest May 2020 Power BI Report Server.

 

When I make a simple API call:

 

http://127.0.0.1/Reports/api/v2.0/System/AllowedActions

 

On the Windows 2016 Server, it comes back in < 150 ms. Making the same call on the WIndows 2019 Server, it takes over 4+ seconds.

 

I wanted to rule out a first time run, or other issues, so I ran each command 10 times. It was consistent. < 150 ms for the 2016 Server and >4000ms for the 2019 Server.

 

I then ran some other tests, running the API call from various places to various endpoints:

 

Ran FromAPI EndpointTime
Windows Server 2016Self148ms
Windows Server 2019Self4205ms
Windows Server 2016Windows Server 2019142ms
Windows Server 2019Windows Server 2016144ms
LaptopWindows Server 2016156ms
LaptopWindows Server 2019153ms

 

As can be seen, calling the API from anywhere to anywhere gets fast response times, except for when I call the API from the Windows 2019 Server to itself.

 

I can't find any differences between the 2016 Server and the 2019 Server that might cause a difference. The only thing I know of off hand is that on 2016 we are running .Net Framework 4.7.2 and on 2019 it is running 4.8. But I doubt that would make the difference.

 

If anyone has any thoughts of ideas, i'm open. We have a simple web app that runs on the server to provide some details via the API. I know I coudl move it off to another server, but I'd rather keep it all together if possible.

0 REPLIES 0

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.