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 →
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 →
Do you want to learn how to create Power BI reports consuming the standard out-of-the-box API’s in Business Central? Ever wanted to know what you can use the BC API’s for in Power BI without the need for any AL development? Then have a look here: Create Stunning Power BI Reports Using the Standard BC … Read More →
A question I recently received is: I created a Power BI report with Business Central data from my Business Central tenant and now I want to publish the report to the tenant of the customer, how does that work? Let’s start with an example report. In this report I will connect to the Customers … Read More →
How do you add a hyperlink (URL) to an RDLC report layout in Business Central? First, get your hands on the RDLC layout. If you are a developer, you can simply open the RDLC layout, because you have it in VSCode. If you are an end user, you need to open the layout in the … Read More →
Want to get started with Excel layouts for Business Central? Then have a look here: http://aka.ms/bcexcelsamples Business Central 2022 release wave 1 (version 20) introduced the feature Excel layouts as a way to layout and run reports using Excel. This repo contains instructions for how you can use different Excel and Power Query features in … Read More →
A long time ago I described how you can add fields to reports in BC: How Do I: Add fields to a Report in Business Central? – think about IT but since then a lot has changed and the Report Extension object was introduced, which is a much better solution. What is a Report … Read More →
In Power BI Desktop, and in the Power BI Service, Maps and Filled Map visuals might show up as follows: Don’t worry, there’s nothing wrong with your report, it’s a new setting, announced in October last year. Back in October, we announced that we were introducing a tenant-level setting to enable or disable Bing Maps … Read More →
In almost every PowerBI report at some point you will require time intelligence. You might want to display information on a timeline or create time based measures using DAX time intelligence functions. For that to work properly it’s a best practice to always create your own Date (or Calendar) table in the Power BI … Read More →
In this post I will demonstrate how you can create simple APIs of type Query and Page to be used in Power BI. The idea is to have a look at an example where we create 2 very simple APIs: a Customers Query and a Customers Page. In VSCode, create a new project using AL:Go! and … Read More →