pbi_create_relationship
Create relationships between columns in Power BI .pbip models using TMDL. Defaults to many-to-one with one-direction filtering to avoid ambiguity; supports custom cardinality and cross-filtering options.
Instructions
Crea una relacion entre dos columnas del modelo .pbip.
Por defecto muchos-a-uno con filtro en un sentido: es lo que crea Power
BI y lo unico que no introduce ambiguedad. cross_filtering
'bothDirections' resuelve casos concretos y complica el modelo entero,
asi que conviene justificarlo.
Escribe en TMDL: requiere el proyecto CERRADO en Power BI Desktop.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| name | No | ||
| to_table | Yes | ||
| is_active | No | ||
| overwrite | No | ||
| to_column | Yes | ||
| from_table | Yes | ||
| request_id | No | ||
| from_column | Yes | ||
| to_cardinality | No | one | |
| cross_filtering | No | oneDirection | |
| from_cardinality | No | many |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |