Extracting All The M Code From A Power BI Dataset Using The DISCOVER_M_EXPRESSIONS DMV

DMVs (Dynamic Management Views) are, as the Analysis Services documentation states, “queries that return information about model objects, server operations, and server health”. They’re also available in Azure Analysis Service, Power BI and Power Pivot and are useful for a variety of reasons, for example for generating documentation.

Source : Chris Webb’s BI Blog
Read more…

Business Central as an app: getting to the al source code

You must have heard the latest news: Microosft released the first devpreview (on docker) where Business Central is an app, and there is close to no C/AL anymore. Either you might have gotten it from the blog from Microsoft, or Stefano’s blog, where he explained how to build an app for it.

I wondered if there was still a way for us to browse the – in this case – the al-code. And even more – would we be able to use the VSCode navigationability (if that’s a word at all) to navigate our code (like “go to definition” and “find references”)?

Bron : Waldo’s Blog
Lees meer…

C/AL Source Code Analysis with PowerShell

Last Directions US and EMEA, I had the opportunity to talk about – uhm – myself. Well, not really – about my tools. It was a weird experience – but it got more attention than I ever expected.

Now, during that session, I showed a tool that I wanted to put out there for sooooo long: a way to analyze your C/AL Source Code with PowerShell.

This was actually an “let’s see what we can do and how far we can go”-challenge during our free time ;-), where the .Net part (which is the majority of the work) wasn’t done by me, although I was quite (let’s say “overly”) involved with the entire evolution of it ;-). The tool might not be completely new to you. I have been using it for quite some time to talk about some things within the product, like:

Bron : Waldo’s Blog
Lees meer…

How to: Customize Microsoft Dynamics Business Central On Premises Using AL Code Functions

If you’re new to Microsoft Dynamics Business Central on premises, you need to know how to easily customize it. In this blog, you’ll learn how to do customizations using AL code functions, including use of Message statements, how to insert a record, and how to modify a record, which makes it easy and fast. This example discusses how to display the information and insert and modify a record in the Customer table using AL Code.

Bron : ArcherPoint
Lees meer…

How to Code in AL for Dynamics Business How develop in Microsoft Dynamics 365 Business Central using Visual Studio CodeCentral Without Using Docker

It’s been a while since I have descended into the blog mines to dig with my hands and find precious blog ore. Today, we’re going to talk about Microsoft Dynamics Business Central (BC) development. Most everything you read about BC development involves using Docker containers. Let’s start with what many of us are thinking:

Bron : ArcherPoint
Lees meer…

AL Code Analysis Rules (Diagnostic Descriptors) – Updated Again

I have been blogging a few times about the Diagnostic Descriptors we get when enabling code analysis. Well – yet again, we have new ones. But I’m not going to keep updating these rulesets, as Microsoft is now doing that on docs. So let me give you one more overview, and the resources to the pages on docs per analyzer.

Bron : Waldo’s Blog
Lees meer…