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 →
Released Cumulative Updates for Microsoft Dynamics 365 Business Central on-premises: https://support.microsoft.com/en-us/help/4470116/released-cumulative-updates-for-microsoft-dynamics-365-business Released Updates for Microsoft Dynamics 365 Business Central 2019 Release Wave 2: https://support.microsoft.com/nl-be/help/4528706/released-updates-for-microsoft-dynamics-365-business-central-2019 Dynamics 365 Business Central On-Premises Spring 2019 Updates: https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/deployment/update-versions-14
Imagine you have created a Power BI report and you want to display in in the Customer list. Then you need to add a report filter in the Power BI report, before you publish it to your work space: Then in Business Central you can go to the customer list page and in the Power … 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:
When you use the Power BI Desktop connector for Business Central: you will see all your environments (production, sandboxes,…): And if you try this in the latest version, with the new look & feel, you will see something like this: Nice to see an idea implemented ! 😎https://t.co/W1AO5qrZMI #msdyn365bc #PowerBI pic.twitter.com/YSCNKTFBUu — Steven Renders (@srenders) … Read More →
Imagine you accidentally delete your launch.json file in your project, or you clone a git repo that does not have a launch.json file, then what do you do? Do you manually create a new launch.json file? Do you copy a launch.json file from another project? Do you go to #bcalhelp and ask for help? These … Read More →
Since the release of the new development environment, some thing have changed… And one of these things is how you, as a developer, run a query. Imagine you have created this amazing query object: Well, in the past you could have simply used Ctrl+R or the Run button in the object designer, to get a … Read More →
I recently was made aware that you can simply unzip the Microsoft Base Application, after you download symbols: How cool is that? (I knew that this was possible with your own apps, I simply did not know it was possible with the Microsoft Apps too.)
I have been waiting a long time for this to become available, but now you are able to create an Office 365 trial environment, for free, which can be used for a whole year. Demos.Microsoft.com has been available for some time now, for Microsoft Partners, and I have used it many times to create demo … Read More →
We at Plataan are proud to present: Business Central Booster, a case based learning program to support the in-stream of new Business Central professionals: In other words: Learn By Doing @ https://businesscentralbooster.com Our full encompassing learning paths will boost you in the Business Central professional life and consultancy practice. Real-world implementation scenario leads your learning … Read More →
Please have a look here, to find recently published learning paths on Microsoft Learn, about Business Central: https://aka.ms/bclearn When you apply the above link, these are the results: Deploy and configure Microsoft Dynamics 365 Business Central https://docs.microsoft.com/en-us/learn/paths/deploy-configure-dynamics-365-business-central Return items in Microsoft Dynamics 365 Business Central https://docs.microsoft.com/en-us/learn/paths/return-items-dynamics-365-business-central Assemble items in Microsoft Dynamics 365 Business Central https://docs.microsoft.com/en-us/learn/paths/assemble-items-dynamics-365-business-central … Read More →