Dynamics 365 Business Central: using OData V4 Bound Actions

I’ve promised this post to some attendees of my last Dynamics 365 Business Central development workshop in Microsoft Italy (c/o Microsoft House) last week.

Question was: How can I call Dynamics 365 Business Central logic from an external application? Simple answer given by all: you can publish a codeunit as web service and use the SOAP endpoint.

Source : Stefano Demiliani
Read more…

Removing HTML Tags From Text In Power Query/Power BI

Recently I found I needed to remove all the HTML tags from some text in Power Query. I searched and found a great – if complex – function from Marcel Beug here, but I realised that since that post was written the Html.Table M function has been added to the language and that it makes the task very easy. In fact it’s basically the same as the solution I blogged about here for extracting URLs from a web page.

Source : Chris Webb’s BI Blog
Read more…

Uplift Data from C/Side objects to an AL extension

One of the biggest headaches right now, is the missing feature for move data from a C/AL table to an extension table without having to do export and import, RapidStart Packages or other funky operations. The idea behind my method is to avoid too much data copying and instead rely on a Rube Goldberg’sk series of SQL rename operations.

Source : Hougaard.com
Read more…

Setting Up and Using Time Sheets in Microsoft Dynamics NAV 2018

For companies that use Microsoft Dynamics NAV and have employees who need to track time against a job, for service, or for HR, there is a feature that does not typically get attention during the initial implementation or if your company is growing. This blog explains how to set up and use the Time Sheets feature in Microsoft Dynamics NAV 2018.

Source : ArcherPoint
Read more…a>

Solving a Complex Time Problem In Power BI

I was delivering some training last week for a customer in Sydney and they participants had an interesting problem where they needed to be able to report on a rolling time window. Think of it a bit like Rolling 12 Months Sales, or average weekly sales over a rolling 4 week period, but instead this problem uses a rolling time window of just a few hours. I have decided to demonstrate how to solve this problem using my own solar electricity data and build a rolling average 3 hourly kWh consumption.

Source : Excelerator BI
Read more…