Now that we have installed and configured Business Central On Premises, let’s see how you can configure and use Visual Studio Code to create an extension. First, let’s verify the service tier development settings: Make sure Enable Developer Service Endpoint has been enabled, and make a note of the Port number (default 7049). Then download … Read More →
After you have installed Business Central On Premises, as explained in the previous blog post, you will notice that Personalization is not enabled: I don’t know why, if this is by design or not, but you can enable it as follows. First, find your navsettings.json file: Here you can find more info on modifying the … Read More →
To install Microsoft Dynamics 365 Business Central On Premises, first obtain the installation DVD. You can download it here: https://mbs.microsoft.com/partnersource/northamerica/support/bconpremdownload Then, select your flavor (localization): Download and unzip it, then run the setup.exe: Click Next in the welcome screen: Accept the eula: Choose your setup options: When you select the Get a free online trial … Read More →
A question I get asked sometimes, during my Power BI trainings is, can I use PowerPoint to display my Power BI reports and dashboards? Yes of course, I usually answer, and then I explain, that in your Power BI workspace, when you select your report, in the File menu there’s the following option: You simply … Read More →
Let’s get started. In Power BI Desktop, select Get Data, More: Authenticate using your Office 365 credentials (email & password), end then select a query: In this case, I’m filtering the navigator on queries that contain the word item in their name, and then I select Edit to verify the query in the query editor: … Read More →
Did you know that you can select the environment you publish to in Visual Studio Code? For example, when you AL:Publish (F5), you then see multiple choices: To accomplish this, simply use a comma (,) in the “configurations” section in your Launch.json file: And voila, that’s it! 🙂
Invite your colleagues to join us for Dynamics 365 Business Central Technical Blitz, one of three live stream events that will help you understand the new features and capabilities and their impact on current customer implementations. You will hear directly from our technical experts as they demonstrate how to integrate and illuminate the One Microsoft … Read More →
I’m not a VSCode expert and there are probably better ways to do this, but I sometimes get a question: Is there an easier way to design an RDL report from within VSCode? Well yes there is. You can create a Task to do it. Open a Project in VSCode and goto your Tasks: Here … Read More →
Did you know that with Power BI you can connect to GitHub and create a stunning dashboard, like this one: Do you recognize it? It’s a dashboard about https://github.com/Microsoft/AL, which is the repo for developing extensions for Dynamics 365 “Tenerife” 🙂 How do I do this you might think? Well, it’s very easy, all you need … Read More →
With the release of the NAV Development Preview – February Update, a new version of the VSIX was released (al-0.14.17461.vsix) that allows you to create the RDLC and WORD layouts for a report with one click. Let’s look at an example. Here I created a report.al object with the following dataset: You can use the TREPORT … Read More →
https://blogs.msdn.microsoft.com/nav/2018/01/16/generate-symbols-in-a-modern-development-environment-with-microsoft-dynamics-nav-2018/
SQL Operations Studio (preview) is a free tool that runs on Windows, macOS, and Linux, for managing SQL Server, Azure SQL Database, and Azure SQL Data Warehouse; wherever they’re running. SQL Operations Studio (preview) is built on top of Visual Studio Code and offers a lightweight, keyboard focused modern code workflow experience when working with … Read More →
https://blogs.msdn.microsoft.com/nav/2017/12/11/smart-solutions-1-artificial-intelligence-and-machine-learning-in-dynamics-nav/ https://blogs.msdn.microsoft.com/nav/2017/12/13/smart-solutions-2-programming-computer-vision-in-cal-code/ https://blogs.msdn.microsoft.com/nav/2017/12/19/smart-solutions-3-custom-vision/
Recently someone asked me how to connect SQL Server Management Studio to the database on a Docker image for NAV 2018. Before I could answer Jakub Vaňák already did and said: “Of course it is. If you want to access the default instance inside one of MS NAV containers you can access it from your docker … Read More →
Using Visual Studio Code as a replacement for Sql Server Management Studio is very easy. Once you have downloaded and installed VSCode (download it here), you need to add the mssql extension in Visual Studio Code, which you can find here. Then create a new file in VSCode and give it the extension .sql. The mssql … Read More →