When a column being used as a relationship key contains the value "#", Power BI is unable to grant a One to Many or One to One relationship. Instead, the Create Relationship dialog box reads "The cardinality you selected isn't valid fo this relationship".
Specific context
When using the SAP Business Warehouse connector, two tables were imported. One, labeled Maintenance Items is the Fact table with various keys. The other, labeled ABC Indicator, is a lookup table with 4 rows.
The key for the last row is '#', something the SAP system uses instead of a blank value across all tables. Nonetheless, all keys are unique for the "One" part of the relationship.
Attempting to enforce a relationship after removing blanks/errors from both tables yields the following error:
By replacing both key columns ([Maintenance Items].[ABC Indicator Key] and [ABC Indicator].[Key]) '#' values with 'NA', we are now able to create a One to Many Relationship:
This bug can be frustrating for users who don't dig and run into a similar scenario.
- rsun_tqb on: Template App "Microsoft 365 Usage Analytics" faili...
- Tortitude on: No able to access Microsoft UI String Search page
-
mattlee
on:
Input Text Slicer Broken on PBI Services
-
mattlee
on:
Input Slicer Bug: Cursor jumps to position 0 and v...
-
mattlee
on:
Input Slicer Causing Browser Tab Freeze in Public ...
- alisonmoraes on: Usuário PPU Sem acesso
-
mattlee
on:
Small multiples not fitting to scale
- Chandanu14 on: AADSTS50011: Fabric MCP Redirect URI missing from ...
- DanArcher on: Unknown Error on Close & Apply
-
vgeldbr
on:
Connection Timeout to Azure Analysis Services (AAS...