Ben Gribaudo

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).

If you’ve used Power Query for any length of time, you almost certainly have joined tables together.

Earlier this month, Microsoft announced the future retirement of gen1 dataflows.

Power Query dataflows like to use GUIDs to reference workspaces, lakehouses and warehouses.

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?

Have a table, but want to change—to override or augment—some of its behaviors?

Power Query’s column types can be confusing.

Type equality is an advanced—and also confusing—Power Query topic.

Did you know that a no selection expression can impact DAX expressions that filter the calculation group, changing their output?

Did you know that, by default, Power Query may round numbers differently than you learned in grade school?