February 2020 – Page 3

Dynamics 365 Business Central and data compression

Yesterday Kennie Nybo Pontoppidan (from the Dynamics 365 Business Central Team) asked us an interesting question: do you use data compression on your Dynamics 365 Business Central on-premise database? If yes, what type of compression? Source : Stefano Demiliani Read more...

18 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

Remove Duplicates and Keep the Last Record with Power Query

Today I was helping a customer with a problem that seemed quite simple on the surface. She had a data table containing historical customer sales orders (each customer has many orders on different dates). The objective was to filter this table in Power Query and just…

17 February 2020

Data & Analysis

Visualising Power Query Diagnostics Data In A Power BI Decomposition Tree

Recently I’ve been working with the Power Query team to come up with some ways to help developers understand the data returned by the new Power Query diagnostics functionality. In this, the first of two posts, I’m going to share a Power Query function that reformats…

14 February 2020

Dynamics NAV & BC Tips & tricks

Follow-up on secret values in a Business Central app

Because I shared the source code, it was not hard to figure out that the navxdata file contained the secret value. What I really wanted to know was if there are ways to get values out of the navxdata file. And it turned out to be…

13 February 2020

Dynamics NAV & BC Tips & tricks

You need the TaskScheduler in your Docker containers

The other night I was working on a new E Foqus App that’s coming out soon on AppSource, and I noticed some strange behaviour. There were operations that simply didn’t happen on a couple of docker containers, but worked great on a cloud sandbox. Source :…

12 February 2020

Dynamics NAV & BC Tips & tricks

How to Develop Business Chart in Microsoft Dynamics 365 Business Central

In this blog, I’m going to discuss Business Chart in MS Dynamics 365 Business Central. Business charts are based on Business Chart control add-in which is provided by the Microsoft.Dynamics.Nav.Client.BusinessChart.dll assembly. Source : VLC Solutions Blog Read more...

12 February 2020