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 →
🚀 I’m really proud to be presenting two sessions at Directions EMEA 2024 in Vienna: Use Power BI to create Business Central insights. In this session, we explore how to use Power BI to analyze what happens in Business Central. Here’s what you can look forward to learning: – Master Data Retrieval: Learn how to … 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 →
As we explore Business Central, Reporting, and Power BI, I want to ensure this blog aligns with what you find most valuable. Your feedback is essential in shaping future posts and covering the topics that matter to you. Share Your Ideas What specific topics interest you? What challenges or questions do you have? Any other … 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 →
It’s almost time for the Business Central Launch Event 2023 Wave 1: https://aka.ms/BCLE The Business Central Launch Event will take place from March 29-31, 2023. During the three days, you’ll be able to participate in a live opening session, watch sessions on what’s new in 2023 release wave 1 and participate in Q&As. After March 31, all sessions will be … Read More →
A few months ago someone asked if if it was possible, using Power Automate, to get documents from Business Central, for example in pdf format and them email them or save them somewhere. At that time I did a few tests and discovered it was simply not possible, using the standard apis. However, with the … Read More →
Business Central 2023 Wave 1 (version 22) is coming, and as from yesterday you can create a preview sandbox, so you can test out all the new amazing features. Simply go to your Business Central Admin Center, and create a new environment: Select Sandbox, and in Version select the (Preview) option. After you click Create, … Read More →
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 →