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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
AdminDev
New Member

PBIRS API call is slow on Server

Scenario:

Browser: IE 11

Query: http://<server>/api/2.0/catalogitems

Number of catalog items is around 200.

When I run this query in browser on my workstation, results come instanteniously.

When I run this query in browser on server, it takes about 5 minutes to receive results.

When the query is exexuted within SSIS C# script task, it also takes about 5 minutes for the query to execute.

PBIRS is installed on the same box with SSIS.

PBIRS version 1.3.6801.38816 (August 2018)

No IIS installed on the server.

 

Why does this 5 minute delay happen?

How can it be eliminated?

Your help is greatly appreciated.

1 REPLY 1
Jon-Heide
Microsoft Employee
Microsoft Employee

Not sure about a 5 minute delay, but a few things to check:

 

1. Is the server in a cold state? Sometimes the first call takes time to load everything into memory. 

2. When you view this in the web portal, is does not pull all items at one time, it filters the list to the just that folder/root being viewed. Hence consider if you re rest call shoud have some filter condition. 

3. Do you have large files? Double check the REST api repsonse if that includes the content payloads. The portal pulls only metadata and not the content. 

4. Look at the server log files, that may give you some indication of where time is spent, or if there is a timeout/error of some sort. 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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