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 →
DynamicsCon March 2022 is a FREE, 3 day virtual learning experience for 8,500+ Microsoft Business Application users and professionals. You will be immersed in programming covering Power Platform, Dynamics GP, and Dynamics 365 products: Business Central, Customer Engagement, Finance & Operations. Have a look at the agenda: Agenda – DynamicsCon And… I’m also speaking: … 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 →
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 →
Dou need to create Power BI reports for Business Central Saas that require data from one or multiple companies from your tenant, then you can use this template: blog/MultiEnvironment at master · srenders/blog (github.com) When you run the pbit file (template), you are asked to login with your office 365 BC credentials: Next a … 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 →
Learning how to customize Business Central Cloud solutions from scratch or transforming your classic Dynamics NAV development knowledge, skill set and heuristics towards modern Business Central development tools including Visual Studio Code, AL and DevOps can be challenging. Read more about it here: Learn Modern Business Central Cloud Development with Visual Studio Code, Git and … 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 →
It’s been a while since I posted, and I have a lot of posts coming about Business Central and Power BI, but I wanted to put your attention first on some idea’s that I created. Let’s have a look at these ideas: Add Business Central as a Data Source in DataFlows Enable incremental refresh for … Read More →
How do you make sure your #BusinessCentral developers are comfortable and stay on track with their competence development at any time? Ilse Daems, the HR manager at GMI group NV, knows how. Read her story here https://businesscentralbooster.com/2021/02/25/business-central-developer-training/ #businesscentral #BusinessCentralBosster #msdyn365bc #msdynamics #msdyn365 #bcalhelp #learningfromhome Our full encompassing core development professional program will boost you in the Business Central customization … Read More →
Interested in some basic and in depth knowledge and lot’s of demos on Power BI and Business Central @Dynconference ? Then vote for me here: https://dynamicscon.com/submissions/?query=renders… DynamicsCon 2021 is a FREE virtual learning experience for Microsoft Dynamics 365 (D365), Dynamics GP, & Power Platform users and professionals happening March 16 – 18 2021. Experience expert … Read More →
Did you know? Since BC introduced the Application App, you should omit the dependencies on the System App and Base App: https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-json-files#Appjson In previous versions the references to base and system application were stated explicitly under dependencies in the app.json file of the extension. Instead you must now use the Application version property in the … 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 →
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 →