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 my case) more than for technicians; these are the things we repeat daily to our customers …and finally Microsoft has decided to formalize them.

Source : Roberto Stefanetti
Read more…

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 any further, though, let me be absolutely clear about something:

Source : Chris Webb’s BI Blog
Read more…

Tables, Numbers, Immutability And Power Query Performance

Following on from my last two posts on Power Query performance, I thought I would write about another trick that can make a big difference to your query execution times. It’s actually something that Ehren from the dev team mentioned in a forums thread that I blogged about here but it deserves to be better known.

Source : Chris Webb’s BI Blog
Read more…

Data Privacy Settings And Data Refresh Performance In Excel And Power BI

I have known for a long time that data privacy checks can have an impact on the performance of data refresh in Power BI and Excel, but on a recent performance tuning engagement I had the chance to observe just how much of a difference changing these settings can make

Bron : Chris Webb’s BI Blog
Lees meer…