Diagnostics – Pardaan.com

Dynamics 365 Business Central v19.X+: AL Compiler Diagnostics (Messages includes URLs)

Today I would like to talk about a simple topic, AL Compiler Diagnostics. This is a new feature of BC19, but I only found it available on BC19.1 recently. Source : Dynamics 365 Lab Read more...

3 December 2021

Data & Analysis

Monitoring Power Query Memory Usage With Query Diagnostics In Power BI

In the April release of Power BI Desktop the Power Query Query Diagnostics feature was enhanced so that you can now return performance counter data. As the blog post says: When you run performance counters, every half second Power Query will take a snapshot of resource…

28 May 2020

Data & Analysis

Adding Your Own Messages To Power Query Query Diagnostics

A quick point: while the Power Query Query Diagnostics functionality is relatively new, it’s based on Power BI/Power Query trace logging that has been around for a while. I’ve just realised that this means you can use the Diagnostics.Trace M function that I blogged about back…

4 March 2020

Data & Analysis

An M Function To Help You Explore Power Query Diagnostics Data

Last week’s post showed an M function that took Power Query diagnostics data and formatted in a way that made it suitable for visualisation in a Power BI Decomposition Tree visual. This is great for understanding what’s going on at a high level, but by doing…

20 February 2020

Data & Analysis

Visualising Power Query Diagnostics Data In A Power BI Decomposition Tree

Recently I’ve been working with the Power Query team to come up with some ways to help developers understand the data returned by the new Power Query diagnostics functionality. In this, the first of two posts, I’m going to share a Power Query function that reformats…

14 February 2020

Data & Analysis

The Diagnostics.ActivityId() M Function

I’ve blogged a few times about the tracing functionality that is built into Power Query/Get&Transform and Power BI (see here and here). The trace files themselves clearly contain a lot of interesting information, but there’s no official documentation about what they contain and the format seems…

29 September 2017