You can easily create a slicer in Power BI Desktop with the Dropdown Style: But can you also add a Search in the slicer, so you can search for a specific value if the dropdown is a long list? Yes you can. Simply click on the dots to select More Options for your slicer, and … Read More →
🎉 It’s here! Business Central 2024 release wave 2 is officially LIVE! 📢 Ready to dive into the newest features? Join us for the Business Central Launch Event on October 8th at 4:30 PM (CEST) and get the inside scoop on everything this exciting release has to offer. Don’t miss it! 🚀 Register now at … Read More →
As from this week you can create a Business Central 2024 Wave 2 Saas Sandbox: You can have a look here at some expected features: New and planned features for Dynamics 365 Business Central, 2024 release wave 2 | Microsoft Learn Microsoft Dynamics 365 – Release Plans This one in particular could be … Read More →
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 →