data mapping

Power BI

16 de marzo de 2022

Easy Management of Referential Integrity

Referential what? it sounds weird, but it's a rather basic thing: It's like asking, do you have all the product IDs of the sales table in your product table? If you don't, then is when that infamous "blank" appears in slicers and all kind of bad things start to happen. Unless you load everything fro...

Leer post →

Power BI

12 de agosto de 2021

Data mapping done right

Hi there. In my previous post on how to set up a "data problems" button I did mention that there was a further improvement to the approach, so here I am to explain what is this about. As you may recall, in my previous installment on the topic, the user is warned that there is[...]

Leer post →

Power BI

25 de julio de 2021

Setting up a "Data Problems" warning (and detail page) in Power BI reports

I've seen it many times. While there is a set of "official" attributes for a product, or a client or whatever, a department may choose to group them through one or more custom attributes. And what do they do? Of course, they create an excel file where they manually maintain a table with the key[...]

Leer post →