Second post in the „Doing Power BI the Right Way“ series. In a business intelligence solution, data must be shaped and transformed. Your data is rarely, if ever, going to be in the right format for analytic reporting. Continue reading →

über Doing Power BI the Right Way: 2. Preparing source data — Paul Turley’s SQL Server BI Blog

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

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

“Post and Print” function in Business CentralThe “Post & Print” function was removed since Dynamics NAV 2017, it has been replaced by the “Post & Send” function which allows you to do more things by configuring specific sending profiles.Now the newly posted document is opened after posting, you can print it from there …but if,…

über Post and Print function in Business Central — Roberto Stefanetti NAV & Business Central Blog

Here is another interesting use case of Row Level Security (RLS). It’s funny that my first post was also about RLS – when you use RLS, lot of different challenges show up (which are not relevant and do not have any use cases without RLS). In this post we are going to look at how […]

über Implement Row Level Security based on business rules in Power BI — PeryTUS IT Solutions

Did you know, Analysis Services (the engine behind Power BI) keeps track of the number of referential integrity (RI) issues in your model? It uses this information to decide if some calculations can take advantage of specific optimisations. When RI issues exist in an IMPORT model, complex expressions will not be able to use all…

über Clean data = faster reports — Phil Seamark on DAX