Reply
Ttaylor9870
Helper III
Helper III

Navision application slow for users at the same time everyday

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

2 ACCEPTED SOLUTIONS
lbendlin
Super User
Super User

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

View solution in original post

avatar user
Anonymous
Not applicable

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.

 

View solution in original post

2 REPLIES 2
avatar user
Anonymous
Not applicable

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.

 

lbendlin
Super User
Super User

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

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

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

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)