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 →
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 →
If you are using Business Central Telemetry in Azure Application Insights, then you might be very interested in this amazing Power BI report: BCTech/README.md at master · microsoft/BCTech (github.com) Use this link to install/update the template app: https://aka.ms/bctelemetryreport The report comes with sample data. To connect the report to an Azure Application Insights resource, you need … Read More →