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’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[…]
Unfortunately, there isn’t a migration tool to convert your Power BI dataflow (gen1) to Microsoft Fabric dataflow (gen2). If you have Fabric capacity licenses, it just makes sense to do that migration because Dataflow Gen2 gives you data destinations into four destinations, which we don’t have in Dataflow Gen1. However, converting Gen1 to Gen2 isn’t Read more about Migrate Power BI Dataflow Gen1 to Fabric Dataflow Gen2[…]
Have you ever considered exporting your entire Power Query Editor project as a single object? Have you thought about what benefits this would bring for you? Things such as version control and team development can be on the horizon, bringing the ability to migrate between tools and services easily. Fortunately, such functionality exists, called the Read more about Power Query Template: One Giant Leap[…]