Forum Discussion
Solved
Invalid Relationship when attempting Many-To-One despite Unique Values
Hey there, When attempting to create a relationship between two tables, Power BI is simply saying that selecting a "One to Many" relationship for a lookup-to-fact table is invalid. Both are from ...
Thank you both for reaching out.
Changing the cross-filter did not work. However, your feedback on it being strange it was an option helped out. SAP Business Warehouse uses "#" as a blank value key (with the intention, I assume, of not using blank values). After replacing all "#" values with "NA" in both [ABC Indicator].Key and [Maintenance Item].ABC_Key, now the relationship shows a One to Many relationship as the default without error.
Before closing this out, where might I be able to report this to Microsoft, assuming this is a bug where Power BI does not escape "#" values?
Thank you all for the help
