In this article I demonstrate a best practice for the writing of a Data Analysis Expression (DAX) in Power BI regarding the use of formatting, variables and comments.The formula used for my demonstration adds a calculated field named Is Supporter to a table named Supporter. This is a table of merged
Read the full article hereIn my previous article I demonstrated how to use Connection Parameters in Power BI for the configuration of the Source step in Power Queries used to load data from Dynamics 365 (Online). In this article I will demonstrate how to use Parameters in Power Query.The following image shows the first three
Read the full article hereIn this article, I demonstrate the use of parameters for connecting a Power BI Data Model to Dynamics 365 (Online). This approach simplifies the subsequent task of updating the Data Source Settings after the Data Model has been published to the Power BI Service. For instance, it may be desired to co
Read the full article hereRecently when configuring a Power BI Data Model for Dynamics 365 I encountered a situation where I was not permitted to create a One-to-Many relationship in the data model between a Dimension table and a Fact table. Power BI automatically created a Many-to-Many relationship between the tables concer
Read the full article herePower Platform unlocks the potential of Dynamics 365 and Office 365. It opens the door for non-software developer users within organisations to manage data and electronic forms, automate business processes and enable mobility. An organisation needs licensing to use Power Platform. In this blog, I wa
Read the full article hereWhen writing and testing DAX formulas, it is important to understand the Evaluation Context in effect for each part of the formula; i.e. Row Context and Filter Context. The purpose of the DAX CALCULATE function is to modify the Evaluation Context of an expression. In this article, I will demonstrate
Read the full article hereIn this article, I will describe how to configure sorting for an Age Group dimension in Power BI that has multiple sets of Age Groups for the same age ranges. The example discussed in this article is based on aggregating Referrals stored in Dynamics 365 by Age Group. The Power BI Data Model has an
Read the full article hereIn Microsoft Dynamics 365 the Opportunity and Opportunity Products entities form a Header/Detail relationship. This is a common type of relationship between entities. Other examples include Quote, Order, Invoice and their corresponding Quote Product, Order Product and Invoice Product entities. In Po
Read the full article hereIn part one of this article, I described my experience of a “not enough memory to complete this operation” error I encountered in Power BI desktop. In this part, I will describe the cause and resolution for this issue. The cause of the issue was actually the formula used for generating the Sequentia
Read the full article herePower BI is a power analytics tool that allows us to visualize our data. We can create reports in Power BI using Dynamics 365 data. In this blog I will walk through the steps to create a connection between a Dynamics 365 instance and make a simple report using it. I will be using Power BI desktop a
Read the full article hereWe can create and share Power BI dashboards with other users, and similarly we can create a personal dashboard in Dynamics 365 and share it with the other users. Occasionally users like to create and share personal dashboards with other users. However, some users might report an issue where they do
Read the full article hereWith the Power BI and Dynamics 365 integration, many Power BI reports and dashboards are created using Dynamics 365 data. However, there are times when we don’t want to maintain charts in Dynamics 365 and Power BI separately. Therefore, it is best to use Power BI dashboard itself in Dynamics 365. In
Read the full article hereThis blog is the second in a series of blogs focused on Microsoft’s analytics service, Power BI. In the previous blog I focused on importing data into the Power BI desktop version, while in this blog I will be focusing on Power Query. The data I imported as an example was from the “Rotten Tomatoes T
Read the full article hereRecently I was fortunate enough to participate in a workshop focused on Microsoft’s analytics service, Power BI. This blog will be the first in a series of blogs describing my experiences with Power BI. In this blog, I will focus on importing data into the Power BI desktop version. The remainder of
Read the full article hereMicrosoft’s business application platform let organizations innovate business solutions faster. It helps them to build and extend modern business applications by composing analytics, user experiences, tasks automation all together using a wide-ranging and integrated set of services. It offers a rich
Read the full article here