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 →
Recently the Power BI connector in Power BI Desktop allows you to harvest the power of Business Central APIs: In the Standard APIs folder you can see all APIs Business Central publishes automatically: API(V2.0) for Dynamics 365 Business Central – Business Central | Microsoft Docs And in the Advanced APIs you can find the … Read More →
A question I receive a lot recently is that after installing Visual Studio, the installation of the RDLC Report Designer produces an error: The install of Microsoft RDLC Report Designer was not successful for all the selected products. This extension is not installable on any currently installed products. The reason for this error is … Read More →
Yes! It’s here! The long awaited Report Inspector in Business Central. Don’t know what I’m talking about, well let me bring you up-to-date: Microsoft Idea · Report Inspector (dynamics.com) And now, with the release of Update 18.3 for Microsoft Dynamics 365 Business Central online 2021 release wave 1, we have these 2 amazing features: Get … Read More →
Yesterday Microsoft announced the availability of preview environments for Business Central 2021 release wave 1, and as of today was able to actually create one 🙂 So how do you do this? Well it’s actually very simple. In your current Business Central Saas environment, open the Admin Center: Or use this URL: https://businesscentral.dynamics.com/YOURTENANTID/admin and replace YOURTENANTID … Read More →
You might be aware of this idea: https://experience.dynamics.com/ideas/idea/?ideaid=c7f30764-d247-e911-867a-0003ff68f3db And if you haven’t yet, please vote 😉 Now recently I came across a post from Bert De Temmerman on Yammer: https://www.yammer.com/dynamicsnavdev/threads/736254082498560 and that got my inspiration flowing… He suggests that when you add this action to the “Report Layout Selection” page, you can export any dataset by … Read More →
Currently there’s a lot of talk about Business Central performance. Microsoft has released and is releasing guidelines, tools about mechanisms to program for performance, analyse and monitor performance. At the same moment there’s also discussions going on on public and private fora about database size and limitations. And last but not least Artificial Intelligence is … Read More →
Try out the new Business Central 2020 release wave 1 functionality today! Learn how to prepare for major updates with preview environments: https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/administration/preview-environments Are you interested to test out all the new bells and whistles of BC version 16, then create your preview sandbox as follows. Go to your Business Central Admin Center: Then spin … Read More →
Imagine you have created an amazing Power BI report that summarizes information using different visuals. Power BI Desktop lets you build advanced queries, models, and reports that visualize data and the idea is that the individual records that come from your data source are aggregated and summarized in your report, giving you the possibility to … Read More →
Performance wise it can be very interesting to use query objects as a data-source in a report (or any other object). Imagine you want to create a report that shows the top X records from a table, let’s say for example Customers, then creating a report dataset with a top-x filtering can be very cumbersome. … Read More →
A question I get a lot in my Power BI training for Business Central, and non Business Central companies is the following: How can I implement an incremental refresh, without building a data warehouse and without buying a Power BI Premium license? And to be honest, the answer is, it’s not really possible, but there’s … Read More →
I recently came across a question in the Business Central forum: How do I get information about Posted Sales Shipments in Power BI? And this is not a standalone question, I get these questions a lot in my training’s that I deliver all over the world. Many times I see answers suggesting to use existing … Read More →
Recently someone asked me, what’s wrong with me report, it’s not showing me the correct data? After investigating I noticed that the report used filters, applied in several different ways and that the expected data was not showing up in the dataset, and then of course it was also not displayed in the layout. So, … Read More →
During my reporting workshops I sometimes get the question, is it possible to create a GreenBar report and how do you do that in a matrix? A GreenBar report is actually a report where you apply shading to every other row or column. So let’s start with a simple example and let’s create a simple … Read More →
Tip of the day: Have you checked out the new #BCALhelp hashtag? Remember that you can use it to ask questions directly to the #MSDyn365BC community. There’s already a lot of informative discussions going on: