Introduction List pages in Dynamics 365 Business Central are central to daily operational work: customers, vendors, items, ledger entries, and documents.What is often overlooked is that these same list pages can also be used for ad-hoc data analysis, without exporting data, running reports, or switching tools. With Data Analysis (Analysis Mode), Business Central allows users … Read More →
At the start of a new year, many people decide to explore Microsoft Dynamics 365 Business Central. This might be because of curiosity, a new role, a new project, a training, a demo or the need to evaluate whether Business Central is the right fit. In all cases, creating a trial environment is usually the … Read More →
Sometimes when you run a report with an RDLC layout, you might get this error: “Rendering output for the report failed and the following error occurred: Report ” contains hyperlinks. The EnableHyperlinks property has not been set for this report.” Now the EnableHyperlinks property needs to be set in the AL part of the report … Read More →
Managing Power BI resources directly from Business Central is now easier than ever with the Power BI Monitor extension. In this guide, I’ll walk you through the complete installation and configuration process, from Azure AD setup to your first data refresh. What You’ll Need Before we begin, make sure you have: Business Central version 25.0 … Read More →
Some time ago I was asked to blog about the possibility to create multi-language Power BI reports. It’s been a while and I did not find much time to research and blog because I was delivering a lot of trainings and working on the content of our plataan.tv trainings. So the question is, I have … 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 →
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 →