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

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! 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
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

60 days of Data Days Carousel

Data Days 2026

Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.