Extract Your Dynamics 365 Business Central Data in Excel in Five Easy Steps
Every once in a while, you need a table in Business Central (BC) that does not have an export to Excel button. The instructions below will give you the ability to export page and table data into Excel as a refreshable file.
Before you start, figure out the table and page you are on by using the help button. In my case, I need a download of the extension deployment logs. I first start by clicking on the ? in the BC navigation bar at the top right corner of the page while on the page where I need to grab the data fields. Then I click on inspect pages and Data.
Next, I locate the name of the page and number:
Then I follow the steps below:
Step 5: Use Transform Data to filter or change column order or just click Load.
Once loaded, you can save this file nd refresh later by click on the Refresh All button on the data tab with the file open.
Need help or have questions, email: email@example.com.