To assist you when developing AL objects in VSCode, there are two very interesting extensions I can recommend: GitHub Copilot GitHub Copilot Chat GitHub Copilot provides autocomplete-style suggestions from an AI pair programmer as you code. You can receive suggestions from GitHub Copilot either by starting to write the code you want to use, … Read More →
Currently Microsoft is updating BC Saas sandboxes to version 23. When you create a new AL project (AL:Go!), and setup your launch.json and app.json files correctly and then try to download symbols, then you might get this error: This AL extension version for Visual Studio Code cannot be used with the specified server. Please update … Read More →
It’s almost time for the Business Central Launch Event 2023 Wave 1: https://aka.ms/BCLE The Business Central Launch Event will take place from March 29-31, 2023. During the three days, you’ll be able to participate in a live opening session, watch sessions on what’s new in 2023 release wave 1 and participate in Q&As. After March 31, all sessions will be … Read More →
A few months ago someone asked if if it was possible, using Power Automate, to get documents from Business Central, for example in pdf format and them email them or save them somewhere. At that time I did a few tests and discovered it was simply not possible, using the standard apis. However, with the … Read More →
Business Central 2023 Wave 1 (version 22) is coming, and as from yesterday you can create a preview sandbox, so you can test out all the new amazing features. Simply go to your Business Central Admin Center, and create a new environment: Select Sandbox, and in Version select the (Preview) option. After you click Create, … Read More →
What are Power BI Dataflows? Power BI Dataflows are a cloud-based ETL (Extract, Transform, Load) service provided by Microsoft Power BI. They allow users to easily create and manage data pipelines, which can be used to extract data from various sources, transform and clean the data, and then load it into a destination where it … Read More →
Kennie Pontoppidan started writing some content and guidance on the topic of data extracts. It is currently on BCTech: https://github.com/microsoft/BCTech/tree/master/samples/ExtractData The focus is on how to extract data as there is tons of content on what to do once you have data in a staging area. The topics discussed in this page are: Extracting data … Read More →
Recently I gave a session at the DDC, Dutch Dynamics Community about Business Central Excel Layouts. Guido Robben made a very nice summary of my session and Vincent van Rens and Dick Mauritz took some amazing photos. You can find it here: Dutch Dynamics Community And here are the downloads: Dutch Dynamics Community … Read More →
A question I see over and over again is: How Do I create a free Business Central trial? So I decided to write a guide, that you can find/download here: blog/BCTrial at master · srenders/blog (github.com) Basically, it’s very simple: You need a unique email adres and for that you can create an Office … Read More →
The Areopa webinar “Why are dataflows so interesting for Power BI and Business Central?“, is now available on YouTube: 20221219 – Why are dataflows so interesting for Power BI and Business Central – YouTube It was an honor to be asked by Luc van Vugt to host a webinar, thanks Luc for the opportunity! If … Read More →
Recently I had a situation where a job queue failed in Business Central. Actually, it had been failing for a few days, and in Business Central, as far as I now, there’s no way, out of the box, to get a notification about that. So, I got thinking, could I be able to ‘create something’, … Read More →
Not so long-ago Excel report layouts were added in Business Central. With Excel layouts for Business Central reports, users can now create and edit report layouts simply by using the full palette of capabilities in Excel such as sliders, diagrams, charts, and pivot tables. On one hand an end user can easily add Excel layouts … Read More →
You might have noticed that on some pages in Business Central where before there was a Power BI Report FactBox, it has now disappeared, like for example on the Item List. Normally you could then go into the menu and ‘activate‘ it. However, since the changes in the menu/actions in version 21 of Business Central, … Read More →
As from today, Microsoft Dataflows support Business Central, out of the box: What is a Dataflow you might think? Well a Dataflow is basically Power Query online. All tasks you typically perform in Power BI Desktop with Power Query (ETL) you can do in a dataflow and the dataflows are stored online, in the … Read More →
In Business Central as from version 20, which is 2022 Wave 1, when you develop a report without a layout and try to run it, like this one: the following error appears: Sometimes the error is different: Report x does not have a layout of type Excel. Normally and in previous versions of Business … Read More →