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.
My last post was about how I got the customized data out of the tenant database into Xml files. That tenant database was from a NAV 2016 application.
I have updated the tenant database to Business Central and I need to bring in some of the data from these Xml files.
With the upcoming Dynamics 365 Business Central October release, all of you probably wondering what kind of new changes it will bring. We already know that we can prepare to say goodbye to C/Side and Windows Client, but what about other major changes?
In this article, Simplanova’s Project Manager Andrius will review new features of Dynamics 365 Business Central October release, that you possibly haven’t heard about before.
A few years ago I blogged about the Table.Profile M function and how you could use it to create a table of descriptive statistics for your data:
Since that post was written a new, optional second parameter has been added to the function called additionalAggregates which allows you to add your own custom columns containing aggregate values to the output of Table.Profile, so I thought I’d write a follow-up on how to use it.
This blog post is primarily directed towards partners who wants to do AL code customization in Microsoft Dynamics 365 2019 release wave 2. Even though the tools can be used for extension development as well, typically people working on extensions already have organized their files.