This is one of the common question that I keep on skipping for a while to write an article about how to export data in Business Central.
The Process is similar but during the Upgrade or writing code we kind of used a function C/AL World CreateBookAndOpenExcel which is not supported with Business Central.
In order to explain import function from excel simply and clearly, For Demo, let’s assume we would like to Import data To Sales Header Table with associated Sales Line entries.
Now that Excel reports connected to Power BI datasets work in Excel Online it opens up a lot of new possibilities for doing cool things with Office Scripts and Power Automate. Here’s a simple example showing how all these technologies can be put together to automatically generate batches of Excel reports from a template.
As you might know, in Business Central and NAV windows client, we can view and save the report dataset from the preview page, similar to the page inspector. For the development of complex reports, it is very important to be able to analyze the data before print. This would be very useful for creating and debugging RDLC reports.
Last week, I saw a question about importing data from Excel file to Business Central using AL Language. A few years ago, the only solution was to use DotNet integration. However, with the Business Central, there is a much quicker and better approach.
Source : Microsoft Dynamics 365 – Ing. Tomáš Kapitán
Read more…
Today’s post covers some programming that is not of my own making. My colleague Andreas Rascher has built a damn cool functionality that allows you to export the dataset of RDLC reports in different formats. Since we think the functionality is extremely useful, we didn’t want to keep it from you.
In this video, I show an old favorite, the Excel Buffer. A great way to get data into Business Central. I create a few handy extra functions to make the experience nicer.