In this article, I will describe some of the differences when using the Dataverse instead of the Dynamics 365 (Online), i.e., OData, connector in Power BI to retrieve data from Dynamics 365 (Online). When creating Power BI data models, I use a template data model that connects to Dynamics 365 (Onlin
Read the full article hereWhen configuring a Power BI data model, the addition of one or more new column to store a calculated duration between two Date/Time values in Days, Hours or Minutes, or perhaps just Total Hours, is sometimes required.This can be done by adding Custom Columns using Power Query or Calculated Columns u
Read the full article hereWhen adding a list of members into a segment from Excel, you can’t always query them from Dynamics 365. There are many scenarios, such as you have a list of email addresses that may or may not exist in Dynamics 365. Microsoft suggests that we add a new field onto contact in this documentation. Micro
Read the full article hereSupport is a necessityAn IT system is like a car. The real cost doesn’t stop when the system is installed. It requires ongoing support and maintenance to keep it working effectively. There’s an ongoing expense that can’t be avoided.‘Suppose you notice your neighbour filling the gas tank of his car f
Read the full article hereIn Dynamics 365 Online, a common and useful way to bulk update lots of records at once is to use Open in Excel Online. This allows us to quickly modify bulk records using an Excel interface, which is also very useful when moving bulk data from one field to another. We can then Save immediately which
Read the full article hereHave you ever been asked to add an additional field or fields to an excel template that you’ve spent time creating calculations, pivot tables and charts for? You would have found that one of the limitations of excel templates is that you can’t change the uploaded document via UI. You may have found
Read the full article hereIn this article, I will demonstrate two methods that may be used for transforming the Option Set Values in Option Set columns to their corresponding Option Set Labels when using an OData Feed to Connect Power BI to Dynamics 365. These methods may be used for any single-select Option Set column retri
Read the full article here“It is a capital mistake to theorize before one has data.” — Sherlock HolmesThe Age of Data“Information is the oil of the 21st century, and analytics is the combustion engine.” — Peter Sondergaard, Senior Vice President and Global Head of Research at Gartner, Inc.The economy of the US and other mode
Read the full article hereThe 2021 Release Wave 2 for Dynamics 365 which will be rolled out from October 2021 through to March 2022 comes with several new features for the user interface that are quite nice. Following are some of the highlights listed below. I have also provided a few videos which explain the features in mor
Read the full article hereIn this article we’ll walk through all the necessary steps involved in setting up a new Application User in Dynamics 365, including creating a new Azure App Registration to use with the App User.Setting up the Azure App RegistrationStep 1:Create an App registration in Azure, under Azure Active Direc
Read the full article hereCustomer EquityCustomer equity is the sum of the discounted lifetime values of the customers of a business.It’s a customer-centric measure of the value of the business and should be a key strategic focus.The way to grow customer equity is with the strategy and tactics of customer relationship manage
Read the full article hereIn this article, I will demonstrate several DAX formulas for Power BI that may be used to calculate whether a date falls within a Leap Year.Here is a table of dates showing the results for a set of dates. You will notice that:· If the Date is blank, then the result is False.· If the Date falls withi
Read the full article hereIn this article, I will demonstrate the use of a Calculation Group to dynamically update the columns displayed by a matrix (i.e Pivot Table) visualisation in Power BI.The following image shows a page from a sample Power BI report. This page provides an analysis of Opportunities Estimated Revenue and
Read the full article hereWhen testing software, recording issues and bugs is one of the time-consuming tasks. You may also need to use several tools to capture all the necessary data e.g., Excel, screen capture tools and paint. The great thing about the Test & Feedback Tool is that you can do all these things with this
Read the full article hereIn this article, I will demonstrate a simple method to format ‘(Blank)’ on a Data Card in a Power BI report as ‘0’ or ‘-’ rather than ‘(Blank)’.This image shows a page from a report in Power BI. Notice that the values displayed by the Data Cards for Open Revenue and Due to Close Revenue near the top
Read the full article here