Solutions Engineer Senior Developer/Database Engineer
If you ve defined joins for any length of time, you re likely familiar with left, inner and full joins, and perhaps even right joins (opposite of a left join). But these aren t the only kinds of joins out there. There are several others which, while their names may not be as familiar, still have practical applications [ ]
If you ve used Power Query for any length of time, you almost certainly have joined tables together. Joins are a common operation—and one with various details and options to be explored. Let s take a few posts to look into some of these interesting areas! Our focus will be topics specific to how Power Query implements [ ]
Earlier this month, Microsoft announced the future retirement of gen1 dataflows. Microsoft left unstated whether dataflows would remain, or be removed from, what is included in Microsoft Power BI Pro and Premium Per User (PPU) licenses. This uncertainty has raised serious concerns in the community. Update: On April 20, Microsoft revised their announcement post, stating [ ]
Power Query dataflows like to use GUIDs to reference workspaces, lakehouses and warehouses. With a GUID reference, you are authoritatively referencing a specific resource, which is good…but working with GUIDs can entail complications, both for humans and CI/CD, which is not so good. I know what lakehouse SomeLakehouse is, but I ll have to look up [ ]
How do you query out the possible label values of the choice columns (a.k.a. picklists or option sets) in a Dataverse/Power Apps table (entity) using Power Query? As part of building a dimension table, here s what I came up with to answer this question. In addition to working with picklist columns, with a slight tweak, [ ]
Have a table, but want to change—to override or augment—some of its behaviors? Not a technique normally needed in day-to-day Power Query, but perhaps useful in certain special scenarios. Imagine that you are pulling a table containing many product rows from a data source. All works well, except for one performance challenge: Counting rows (e.g. [ ]
Power Query s column types can be confusing. You can create or ascribe a column with any type—regardless of the kind of values in the column—and Power Query won t complain, nor will the values in the column be transformed to the specified type. On the other hand, use Power Query s change type functionality and the chosen [ ]
Type equality is an advanced—and also confusing—Power Query topic. Sometimes, equality comparisons between type values seem to work as intuitively expected; other times, they may not. What s going on? Is it okay—is it safe—to use the equals operator between type values? But first: Why the confusion around this subject? The M language specification lays out [ ]
Did you know that a no selection expression can impact DAX expressions that filter the calculation group, changing their output? While not a bug, this behavior may be unexpected so is something to be aware of. To explore, we ll use this setup: The above, along with a placeholder table, can be set up using the [ ]
Did you know that, by default, Power Query may round numbers differently than you learned in grade school? Unlike DAX, Microsoft Excel and Microsoft SQL Server, which use commercial rounding as their main or default approach to rounding, Power Query is different: it defaults to banker s rounding. What s the difference between these two ways to [ ]