Performance – Page 4

Tip #68 | Using Read-Scale Out in Business Central to improve Performance

Another quick tip for something I’ve used this week to help out a QBS partner with performance issues on Business Central. Since the last release it’s possible to issue read-only commands on a real-time copy of your Business Central database by using the DataAccessIntent property. Source…

21 May 2020

Data & Analysis

Speed Up Data Refresh Performance In Power BI Desktop Using Table.View

It can sometimes be frustrating to work with slow data sources or complex Power Query queries in Power BI Desktop: you open the Power Query Editor, make some changes, click Close & Apply and then wait a loooong time for your data to refresh. Source :…

20 May 2020

Dynamics NAV & BC Tips & tricks

Performance of Test Code

Let’s talk about the performance of the test code that we write for Business Central. What do I mean by “performance” and how can we improve it? Defining “Performance” Obviously, before we set out to improve something we need to have an idea of what it…

30 April 2020

Dynamics NAV & BC Tips & tricks

Monitoring Dynamics 365 Business Central AL Functions Performance with App Insights

Recently I was involved in the project to build a Dynamics 365 Business Central App, which gathered all inventory information from Purchase to Sale, including transfers, production orders, etc. in one place, with one goal – to understand the profitability of each line in each purchase…

21 April 2020

Data & Analysis

Make Your Power BI Report Run Faster By Showing The Same Data In Fewer Visuals

Before we go any further, I don’t want you to go and change your reports if you’re not going to get any benefit from doing so. Use Performance Analyzer (as shown here) to determine which visuals on your report are the cause of slow performance –…

27 February 2020

Dynamics NAV & BC Tips & tricks

Business Central – How to make it go FAST!

Microsoft in late January and early February published a series of pages on Microsoft Docs dedicated to performance with Business Central (On-premise, Cloud). They are all very interesting, in particular, I want to report this page because it is very interesting for functional consultants (as in…

17 February 2020

Data & Analysis

Performance Overhead Of Using Power BI Custom Visuals

Following on from the series of posts I wrote last month (starting here) about testing the performance of Power BI reports in the browser, I would now like to highlight one possible cause of slow report rendering performance: the over-use of custom visuals. Before we go…

14 January 2020