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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Kashinoda
Advocate I
Advocate I

Reports sometimes taking 60+ seconds to load (SSAS live connection)

Hi,

 

We have an issue on our server where reports are sometimes taking a long time to load. This usually happens when the server has been idle for a period but it may happen when a new user loads reports for the first time (it's hard to test due to sporadic nature). This happens on datasets that are regularly processed as well as those that aren’t. The DAX queries are simple and it's a refined model we've used for years, no issues in Power BI Desktop.

 

In SQL Profiler I can see the following events and timings when the report is loading.

Discover End -  56 Seconds
Audit Logout - 56 Seconds

Query End - 52 Seconds

Query End - 52 Seconds

Query End - 52 Seconds

Query End - 52 Seconds

 

In IE and Chrome using development console I can see the above queries, either with a 'Stalled' or 'Waiting' timing message.

4KRcOXr

 

Prior to this there are a series of 401 errors, this may be a red herring as these are only visible in IE. The issue is present regardless of browser.

Dp46HBw

 

I've disabled Loopback Check on the server to remedy the potential authentication issues above. I've also setup a job which runs every two minutes and sends queries to the Tabular Model - unfortunately this doesn't seem to keep the data 'warm'. There are no notable entries in PBIRS logs either.

 

The server is a Zeon E5-2560 4 Core with 48GB of RAM and Enterprise SQL, error present on older and latest version of PBIRS. Using Perfmon I can see we're no where near any memory limitation in SSAS and should be caching everything.

 

I'm not really sure what else to try, any feedback greatly appreciated.

 

1 REPLY 1
Kashinoda
Advocate I
Advocate I

Bump 🙂 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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