- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Consult the Gateway QueryStart and QueryExecution logs to identify the culprits (QueryExecution) and the queries they are running (QueryStart)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Consult the Gateway QueryStart and QueryExecution logs to identify the culprits (QueryExecution) and the queries they are running (QueryStart)

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
12-02-2024 12:23 PM | |||
11-10-2024 04:08 PM | |||
11-25-2024 11:00 PM | |||
11-29-2024 11:36 AM | |||
01-31-2023 01:31 AM |
User | Count |
---|---|
3 | |
2 | |
2 | |
2 | |
2 |
User | Count |
---|---|
8 | |
2 | |
2 | |
2 | |
2 |