topic Navision application slow for users at the same time everyday in Report Server

Navision application slow for users at the same time everyday

Ttaylor9870 — Mon, 05 Aug 2024 15:03:28 GMT

Hey Experts, Afternoon!

I have a PBI gateway connection to Navision, at the same time everyday it becomes slow for users because of Power BI. I've also already tried spacing the refresh schedules out.

I can see the CPU & Memory usage and it becomes extremely high, how would I go about fixing this or has anyone had this issue before?

Many Thanks,

Taylor

Re: Navision application slow for users at the same time everyday

lbendlin — Fri, 02 Aug 2024 21:24:56 GMT

Consult the Gateway QueryStart and QueryExecution logs to identify the culprits (QueryExecution) and the queries they are running (QueryStart)

Re: Navision application slow for users at the same time everyday

Anonymous — Mon, 05 Aug 2024 01:38:45 GMT

Hi Ttaylor9870 ,

Thank you for lbendlin answer ,and I have other suggestions for you:

Adjust gateway performance based on server CPU | Microsoft Learn, this information is provided, please run the Power BI gateway on a different computer than the Navision server

The gateway should be located on a separate computer (not a domain controller) with memory, or even a powerful workstation.

Monitor and optimize on-premises data gateway performance | Microsoft LearnPoint out that by default, gateways do background processing before returning data, which may degrade performance

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.