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

Join 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.

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
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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