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…
What-if in Excel and Business Central Data
Blog
Business Central, Excel and Python a good combination?
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…
Preview BC25: Word add-in to the rescue
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…
Mirroring your Azure SQL Business Central Database
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…
Create your BCPT scenarios with page scripting and AI
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…
Analyse your Business Central Telemetry in Microsoft Fabric
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…
From Business Central to Dataverse to Fabric
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…
BC24: Manual integration mapping with Dataverse and Business Central
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…
Trigger A Fabric Notebook Through The API
When you want to schedule the export of bc2adls (Bertverbeek4PS/bc2adls) you also must schedule the export of the Fabric Notebook after the export from Business Central to Microsoft Fabric is…
How to: Business Central Flowfields inside Microsoft Fabric
In the past days I was asked from random people how you can simulate the flowfields inside Microsoft Fabric when you are using bc2adls tooling (Bertverbeek4PS/bc2adls).That is because when you…