Extract – Pardaan.com

Dynamics 365 Business Central: How to extract characters from a string (indexing with [])

Today I would like to share another mini tip about Business Central, how to extract characters from a string. For example, we want to know what the fourth letter of a customer’s name is, or want to add a space between each character. How to do…

12 September 2023

Dynamics NAV & BC Tips & tricks

How to Extract BC 365 Base App using artifacts

Probably most of you already know that with the Dynamics 365 Business Central 2019 Wave 2 release, we have the ability to modify the Base App. But to extract Dynamics 365 Business Central Base App as .al files that would compile might be quite difficult. As…

7 April 2022

Dynamics NAV & BC Tips & tricks

How to Extract Dynamics 365 Business Central Base App

Probably most of you already know that with the Dynamics 365 Business Central Wave 2 release, we have the ability to modify the Base App. But to extract Dynamics 365 Business Central Base App as .al files that would compile might be quite difficult, so in…

15 January 2020

Data & Analysis

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…

15 May 2019

Data & Analysis

Query by Example to Extract YYYY-MM from a Date Column

I was answering a question for a student in one of my online training courses this week. The question was, “Do you know of a way in power query to efficiently extract YYYY-MM from a Date column?” This can be done ‘manually’ with multiple steps including:…

7 March 2019

Data & Analysis

Extract Numerical Data Points from an Image

Today Gartner released the 2019 magic quadrant for Business Intelligence. As expected (by me at least), Microsoft is continuing its trail blazing and now has a clear lead over Tableau in both ability to execute and completeness of vision. I thought it would be interesting to…

1 March 2019

Data & Analysis

Using Html.Table() To Extract URLs From A Web Page In Power BI/Power Query M

Last year I blogged about how to use the Text.BetweenDelimiters() function to extract all the links from the href attributes in the source of a web page. The code was reasonably simple but there’s now an even easier way to solve the same problem using the…

4 September 2018