What if you could combine the features in Business Central and Excel? Well that
is already possible. In Business Central you can export your data into Excel
reporting and you can use the standard Excel features!In this example I’m using
the What-I...
Microsoft introduced Python in Excel a couple of months ago:Get started with
Python in Excel – Microsoft SupportWith this feature you can easily create
python code inside Microsoft Excel. You can do this by just type ‘=py’ in a
shell and you can c...
In the last releases the product team did a really good job on the “no-code”
option for reports. They introduced the “Analyse view” and Power Bi reports out
of the box. But that is only for analyzing your data. What was missing is a
“no-code” opti...
It was already in preview a couple of months ago. But know in Fabric you can
mirror your Azure SQL database into Microsoft Fabric. NB: be aware that the
option is this in preview when writing this post and got limitations. Those
limitations you ca...
When you want to create a Business Central Performance Toolkit (BCPT) scenario
it can always be hard for a developer and a functional consultant. This because
the developer doesn’t know the functionality and sometimes for the functional
consultant...
Sometimes you want to analyse your data in PowerBI. There is already a great
PowerBI report from Microsoft that you can download. Details you can see
here:Analyze and monitor telemetry with Power BI – Business Central | Microsoft
Learn But sometim...
Currently is it possible to have a shortcut in Microsoft Fabric to Dataverse.
With a shortcut the data will stay in Dataverse and Fabric users can lookup and
work with the data.To setup the connection you can do it in Dataverse or in MS
Fabric. Fa...
In the past it wasn’t possible to create manually a simple integration mapping inside Business Central without any coding. You have to create allot of code. See the Microsoft Documentation:Customizing an Integration with Microsoft Dataver...