Latest Power BI and AI articles from RADACAD team
This article explains the setup instructions to work with the Service tab of the Power BI Helper. Download Power BI Helper from here. Power BI Helper is a third party application, and any third party application if wants to connect to your tenant, needs to be authorized. You need to give permission to the Power Read more about Register Power BI Helper in Your Tenant[…]
I have previously written about What dataflow is and scenarios of using it. I also wrote an article about Computed Entity and the important role of that for performance and data lineage. However, a Computed entity is a premium-only feature. There are sometimes that you don’t really need premium functions of Power BI, and only Read more about Workaround for Computed Entity in Power BI Pro: Dataflow in Power BI[…]
As starting my Power Apps learning journey from the last 6 months, I presented a session on Power Apps in Microsoft Ignite Sydney 2019, In that session, I demonstrated some of the features for Power Apps. One of the features that was interesting to me was Barcode Scanner for web browser available in the Preview Read more about Barcode Scanner with Microsoft Power App[…]
I have written about Date Dimension in Power BI in many posts, and it makes sense now to explain one of the most common performance challenges that I see in some of the models. Sometimes, your model size grows significantly big, and you have no idea why!? In this article, I will show you one Read more about Performance Design Tip for Power BI: Be Careful of Dates[…]
In the previous post, you learned about the challenge of security when Implementing it using multiple positions scenario combined with organizational hierarchy. We started to implement the solution using DAX in row level security. This post is the second part of the solution. Prerequisite The sample dataset for this example can be downloaded from here. Read more about Dynamic Row Level Security in Power BI with Organizational Hierarchy and Multiple Positions in Many-to-Many Relationship – Part 2[…]
I have written previously about Dynamic Row Level Security, and some of the patterns of it. Two of the most common patterns that I explained were; Organizational Hierarchy, and Many to Many situations of users and profiles. Recently I came across a couple of questions, which persuaded me to write about another pattern of dynamic Read more about Dynamic Row Level Security in Power BI with Organizational Hierarchy and Multiple Positions in Many-to-Many Relationship – Part 1[…]
The article that I wrote earlier this week about the shared dimension had a lot of interest, and I’m glad it helped many of you. So I thought better to write about the basics of modeling even more. In this article, I will be focusing on a scenario that you have all faced, however, took Read more about Combining Dimension Tables in Power BI using Power Query: Basics and Foundations of Modeling[…]
I have previously written about using Power Query for creating calendar tables, However, some people still love to do that in DAX. There are a couple of DAX functions which makes the process of creating a calendar table very simple and easy; Calendar() and CalendarAuto(). In this short blog post, I’ll explain what are these Read more about Creating Calendar Table in Power BI using DAX Functions[…]
Although very simple, still I get this question very often; How can I show the total value as a data label in a stacked column chart? In this quick blog post, I’m going to show you a quick and easy method to use a combo chart and show the total as a label on top Read more about Showing the Total Value in Stacked Column Chart in Power BI[…]
For a data warehouse professional, a shared dimension concept is always clear, and a star schema design always includes such type of entity. However, in the Power BI user’s world, there are many users who are not coming from a data warehousing background. It is necessary to understand some of the concepts in order to Read more about Creating a Shared Dimension in Power BI Using Power Query: Basics and Foundations of Modeling[…]