Enum Object in Business Central – How to create and how to extend!

Since the dawn of Business Central Era (2nd April 2018 – Today), there are many new data types introduced by Microsoft. One such data type is Enum(Enumeration). Essentially, what enumeration is having a single select value with multiple options at a given time!

Well, I know what your thinking what about the ‘Option’ data type.
Anyways, enough of talking let’s just dive in!

Source : OLISTERR’S NAV/BC – BLOG
Read more…

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…

Using The “Skip Test Connection” Option For Power BI Data Sources To Avoid Scheduled Refresh Failures

One of the most popular blog posts I have written in recent years is this post on how the RelativePath and Query options for the Web.Contents() M function can be used to allow datasets that use web services as data sources to refresh successfully in the Power BI Service. It’s very frustrating when you write some complex M code in Power BI Desktop and find that your dataset can’t be refreshed after it has been published!

Source : Chris Webb’s BI Blog
Read more…

How to manually upgrade to Dynamics 365 Business Central events

If you just started working with Dynamics 365 Business Central events, you should read this short article from Microsoft first. If you are already familiar with what the events are, let‘s dig further into that. Everyone knows that 365 Business Central Upgrade to events might be real trouble sometimes. In this blog post, I will explain how to manually upgrade Dynamics 365 Business Central Code to events.

Source : Simplanova
Read more…