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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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