Extreme long time of response when creating Scheduled refresh plan or access via SSMS to PBIRS

[josef78]

I have some complicating issues with extreme long time (over ten minutes) of response with some management operations with PBIRS.

Issues:

-When creating (or editing) Scheduled refresh plan on web portal, on finish action (Create or Save action) it take extreme long time (tens minutes) to response (or fails in some cases). If after this successful (and longtime waiting) operation I try create or edit additional Refresh plans, it are processed immediately.

-When try connect from SSMS to PBIRS instance (on http(s)://<servername>/ReportServer) it fails after some time. When I try to connect after successfully finished action with Refresh plan, SSMS connect immediately.

-When try open http(s)://<servername>/ReportServer via browser, there no response from server. When I try to open after successfully finished action with Refresh plan, page is opened immediately.

Problem is probably with PBIRS Web Service (not Web Portal) API on http(s)://<servername>/ReportServer , which is not accessible during standard operation, and it take long time to start.

I have these issues on both my environments, both with scale-out deployment, and both with multiple url defined (http and https).

Similarly issues (probably same problem) is also described here https://community.powerbi.com/t5/Report-Server/Issue-with-scheduler-refresh-on-PowerBI-report-server...

Do you have anyone same issues? Is there any solution? Thanks

[KBO]

Hi @josef78 ,

in this link you can find some helpful advices: https://community.powerbi.com/t5/Report-Server/Power-BI-Report-Server-Extremely-Slow/td-p/677935

I would look if your SSAS runs correctly - all refreshes are stored and processed there.

Best,

Kathrin

If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!

[josef78]

Hi @KBO 

no no, report execution is running fine (including loading models from catalog to SSAS, execution report queries and rendering visuals, and also including Refresh data execution). 

These issues are related only to specific management operation (like create scheduled refresh plan) which are using http(s)://<servername>/ReportServer API (not using web portal URL http(s)://<servername>/Reports)

[josef78]

Any other idea? Thanks