The release plan for Business Central 2024 release wave 2 is now live! Discover what’s new and planned for Dynamics 365 Business Central at http://aka.ms/BCReleasePlan. What interests me the most is: Some interesting Power BI reports coming: Finance: 14 reports Sales: 12 reports Purchasing: 13 reports Inventory: 7 reports Manufacturing: 11 reports Projects: 6 reports … Read More →
When you create a Power BI Dataflow with the Business Central connector, you might get the following error: The OData connector failed with the following error: We cannot convert the value null to type Duration. The error mentions a conversion of null into a type Duration. This got me thinking. Let’s have a look at … Read More →
To assist you when developing AL objects in VSCode, there are two very interesting extensions I can recommend: GitHub Copilot GitHub Copilot Chat GitHub Copilot provides autocomplete-style suggestions from an AI pair programmer as you code. You can receive suggestions from GitHub Copilot either by starting to write the code you want to use, … 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 →
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 →
Many times when you create a company in Business Central for a BE (Belgium) tenant, you will get your Cronus demo data in French when you actually wanted it in Dutch. If you have a Belgian trial version of Business Central and you are using the ENGLISH language in Business Central, THEN the setup … 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 →
Did you know that Windows 10 came with a free remote control tool called Quick Assist? Quick Assist is an app in Windows 10 that enables you to receive or provide assistance over a remote connection. Here’s a video about it: https://www.microsoft.com/en-us/videoplayer/embed/RE4FyMn?pid=ocpVideo0-innerdiv-oneplayer&postJsllMsg=true&maskLevel=20&market=en-us Give assistance Select Start > Quick Assist (or select the Start button, type Quick Assist in the search box, … Read More →
Yesterday Kennie Nybo Pontoppidan (@KennieNP) / Twitter announced on twitter that the new PowerPoint deck “Using telemetry to improve your partner practices and processes” is now available. You can find it here: BCTech/samples/AppInsights/Presentations at master · microsoft/BCTech (github.com) You can use it to evangelize the use of telemetry apart from troubleshooting, or to … 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 →
Introducing the new landing page for all things related to reporting and data analysis in Business Central: http://aka.ms/bcreporting Similar to landing pages for security (http://aka.ms/bcsecurity), telemetry (http://aka.ms/bctelemetry), and performance (http://aka.ms/bcperformance), the new landing page should answer all questions that prospective or existing customers (or you) have about #msdyn365bc reporting. Please visit http://aka.ms/bcreporting and let … Read More →
Recently Microsoft added the Table Information page to Business Central. See here. And underlying are these objects: Table Information (8700, List) Table Information (2000000028) So I was thinking, hey let’s use this in Power BI. Then my first thought was to create a query object using the Table Information table as a data item, but … Read More →
Recently I stumbled upon Manage Sessions in the Business Central Admin Center: In the Admin Center, open an environment: Then select: Manage sessions: Now you can see and cancel sessions: More information is available here: https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/administration/tenant-admin-center-environments#managing-sessions The Manage Sessions page displays information about active sessions on an environment and lets you cancel selected sessions. To open … Read More →