Power Query is one of those tools that has been close to my heart for a very long time. I wrote a full book on it, I have trained thousands of people on it, and I talk about it constantly. So when I get to sit down with the Product Manager behind Power Query and Read more about Power Query, Dataflows, and What’s Next — A Conversation with Miguel Escobar | Fabric Insider Ep. 3[…]
Power Platform Dataflow: A Practical Replacement for Power BI Dataflow Gen1 Microsoft has announced that Power BI Dataflow Gen1 (analytical dataflow) is being retired. If your organization is not ready to move to Microsoft Fabric — whether due to budget constraints or strategic timing — you still have a solid option: Power Platform Dataflow, also Read more about Power Platform Dataflows instead of Power BI Dataflow Gen1[…]
If you have worked with Power BI for a while, you have probably heard the word “dataflow.” But here is the thing — when people say “dataflow,” they might mean three completely different things: Dataflow Gen 1, Dataflow Gen 2, and Dataflow Gen 2 CI/CD. Each version has its own licensing requirements, destination options, and Read more about Different Versions of Dataflow in Power BI and Microsoft Fabric[…]
If you’re looking for simple data preparation for Power BI using Power Query, the Column from Examples feature lets you describe the result you want and Power Query writes the transformation for you—no M code required. In this guide I’ll show practical recipes (full name, weekday name, “first three letters,” and more), how to choose Read more about Simple Data Preparation for Power BI Using Power Query: A Hands‑On Guide to “Column from Examples”[…]
Using Merge in Power Query gives you the ability to join on a EQUAL join with one or more fields between two tables. However, in some situations you need to do the Merge Join not based on equality of values, based on other comparison options. One of the very common use cases is to Merge Read more about Dates Between Merge Join in Power Query[…]
Power Query gives you the capability of joining (merging) tables together using key columns, and there are multiple types of Merge types to choose from. There is another way to merge tables especially when the data source is a relational database system. In this article and video, You will learn how this options works. Video Read more about Merge Data Tables Easily in Power BI and Power Query using Include Relationship Columns Feature[…]
Have you ever wanted to match two tables together but not on exact matches, but also on a threshold of similarity? if your answer to this question is yes, then this feature is built for you. Let’s explore in details how the fuzzy matching works in Power BI. To learn more about Power BI, read Read more about Fuzzy Matching in Power BI and Power Query; Match based on Similarity Threshold[…]
Finding rows that are in one table, but not the other is one of the most common scenarios happening in any data related applications. You may have customer records coming from two sources, and want to find data rows that exist in one, but not the other. In Power Query, you can use Merge to Read more about Find Mismatch Rows with Power Query in Power BI[…]
As I mentioned earlier in Power BI online book, Power Query is a functional language. Knowing functions is your best helper when you work with a functional language. Fortunately Power Query both in Excel and Power BI can use shared keyword to reveal a document library of all functions. I’ve written about shared keyword almost Read more about Power Query Library of Functions; Shared Keyword[…]
There has been a lot of hype recently about Generative AI and Copilot in Microsoft. Microsoft Fabric incorporates many of those features, and one of the areas it has been added to is the Dataflow Gen2 in Microsoft Fabric, or we can also call it Power Query in Power BI Service Dataflows. In this article Read more about Copilot in Power Query in Power BI Service and Microsoft Fabric Dataflow Gen2[…]