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[…]
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[…]
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[…]
One of the most common transformations in Power Query is the Remove Duplicates. This transformation is used in many scenarios, one of the examples, is to create a dimension table with unique IDs in it, so can be used as the source of a one to many relationships to fact tables in the relationship diagram Read more about Remove Duplicate Doesn’t Work in Power Query for Power BI? Here is the Solution![…]
In previous articles, I explained what is the Dataflow and where to use it, I also explained how to create a dataflow, and what is the common data model. In this article, I’m explaining one of the differences between Dataflow and the Power Query in Power BI Desktop, which is Linked Entities and Computed Entities. Read more about Linked Entities and Computed Entities; Dataflows in Power BI Part 4[…]
These days, Dataflow (Power Query in Power BI Service) is a new feature that has been released. according to[1]: Dataflow is a Power Query process that runs in the cloud independently from any Power BI reports. If you want to know more about dataflow see [1] There is a new feature in dataflow that Read more about AI in Dataflow, Power BI webservice, Cognitive Service -Part1[…]
In the last two articles, you have learned what is Dataflow and sample use case scenarios of that in Power BI, and also you learn how to create a dataflow. Before going any further in the dataflow discussion, we have to make a quick pause and talk about the Common Data Model (CDM). Dataflow integration Read more about What is the Common Data Model and Why Should I Care? Part 3 of Dataflow Series in Power BI[…]
Intro: In my younger days, I enjoyed playing computer games and in particular, maze-based games. So for the latest addition to my series of DAX based games, I thought I would have a crack at building a game in Power BI that allowed the user to appear to control a character through a maze to Read more about Fun with DAX – A-Maze-ing DAX[…]
To build a robust BI system, you need to cater for errors and handle errors carefully. If you build a reporting solution that the refresh of that fails everytime an error occurs, it is not a robust system. Errors can happen by many reasons, In this post, I’ll show you a way to catch potential Read more about Exception Reporting in Power BI: Catch the Error Rows in Power Query[…]
In this blog post, I am going to show how to use the Azure ML web service in Power BI (Power Query). First Step: You need to create a model in Azure ML Studio and create a web service for it. The traditional example in Predict a passenger on Titanic ship is going to survived Read more about Power BI and Azure ML make them work with Power Query[…]