This is an intro post to the Error Message Mgt. codeunit and related objects. NAV has never brilliant when it comes to error handling, for a couple of reasons. The error messages themselves sometimes leave a lot to be desired The whac-a-mole nature of fixing multiple errors by finding one at a time and attempting […]

über (Slightly) More Elegant Error Handling in Business Central — James Pearson

This is a quick post for giving a response to a question that comes out in our latest Microsoft’s webcast about creating cloud-based workflows for Dynamics 365 Business Central. In this training I’ve talked a lot about the „When an HTTP request is received“ action in Power Automate (and on Azure Logic Apps too) and […]

über Securing your HTTP triggered flow in Power Automate — Stefano Demiliani

Business Central Virtual Event

Konnte gestern etwas in den Event reinschauen:

Vor allem hat mich dieser Beitrag interessiert. Ich finde die Integration mittlerweile als sehr gelungen.

Vor allem die Roadmap ist für mich von Interesse. Virtual Entities machen es in der Zukunft möglich, NAV-Daten ins CDS virtuell bereit zu stellen. Es sollen sogar CRUD Operations möglich sein. Das macht für mich vor allem bei der Entwicklung von Hilfstools in PowerApps viel Sinn.

Hier noch ein paar Infos zu aktuellen Stand der Virtual Entities sowie zum Gegenstück in AL:

Create and edit virtual entities that contain data from an external data source

AL Table Proxy Generator

Azure File, Azure Blob and Alibaba Cloud integration in Business Central (with interfaces and telemetry)

Yet another

A codeunit to upload files to different containers, implemented with interfaces and monitored with telemetry


  • The requirement is to replace the reference of „File Management“ codeunit with a new „Azure File Management“ for the SaaS (Cloud) version of Business Central.
  • I want to implement a base „app“ that manages file basic operation on different cloud platforms: upload, download, create folders, copy and move files and folders.
  • I want the app to be reusable by all other app depending on it.
  • I want to monitor the activity with telemetry and application insights.


This project allows me to use in the real world two of the new powerful and wonderful features of Business Central: interfaces and telemetry. Interfaces are available with a minimum of runtime 5 (you have to kiss goodbye older versions of BC).


One of the…

Ursprünglichen Post anzeigen 292 weitere Wörter

Power BI Governance – Why you should consider to disable Export to Excel

Data - Marc

Recently, I posted a poll on Twitter to vote for new blog topics. One thing that popped-up in my mind, was more on the governance side of Power BI. A topic where I spend a lot of my day-to-day time, but is maybe less interesting for others? At least that is what I thought. Below the results.

Governance is a new topic for me to write about and less technical than I’m used to. New to this topic? Governance can more less be described the guidelines and settings on a higher framework level that defines what you can and what you cannot do with a specific product or service. It enables the organization in…

Ursprünglichen Post anzeigen 1.776 weitere Wörter

very good article. Put the ftp handler in an Azure function makes it easily reusable. I myself would consider to use winscp within the Azure function to have even more flexibility

Stefano Demiliani

In our recently released „Mastering Dynamics 365 Business Central“ book, in the Azure Function chapter I’ve provided a full example on how to upload and download a file to Azure Blob Storage from a SaaS environment (this was one of the top request I’ve received on all my trainings this year). But many of you have also raised a new more request: in a Dynamics 365 Business Central SaaS environment, how can I save a file to an SFTP server?

This is an operation that you cannot do directly from a SaaS tenant, simply because from here you don’t have access to local resources and you cannot execute custom code. In this blog post I want to give you a possible solution that involves using a C# Azure Functions.

The Azure Function that we’ll use for this task is an HttpTrigger with a function called UploadFile defined…

Ursprünglichen Post anzeigen 716 weitere Wörter

Lesestoff / Linksammlung

Momentan habe ich echt viel zu tun, trotzdem gibt es immer mehr als genug neuen Lesestoff. Nachfolgend ein kleiner Auszug, muss zugeben, habe selber noch nicht alles gelesen. Aber dafür ist dieser Blogbeitrag ja da, sprich ich kann später nachschlagen…

Power Platform:

Codeunit API’s in Business Central

Power Apps Community Plan without Office 365

Using Power BI service without an Office 365 account

Currency Conversion in Power BI Reports


Moving X-Axis in Power BI

Analyzing PASS SQL Saturday data using Power BI

Paginated Reports Bonus Tutorial – Use the XMLA endpoint to create a live connected Excel table

Read API Data with Power BI using Power Query


NAV Business Central:

Codeunit API’s in Business Central

Business Central Blog

Import Tenant Data

How to use the Excel Buffer in Business Central cloud

Another great BC Blog

And another great Blog….

Dynamics 365 Business Central Workflows Auto Posting Transactions




Split Delimited String with Split Delimited with PARSENAME function



Cloud ETL With Azure Data Factory & CDS

Custom Logging and Auditing of ADF Data Flows

Syncing on-premise databases to Microsoft Azure Cloud using Azure Data Factory

Azure Functions Live – Feb 2020



Typescript – The Excel VBA Killer?