Forum Discussion
Solved
Relation with null value for dimension key in fact table errors on creating a report
I have a 1:N between a dimension table and fact table in Fabric LakeHouse. Note that some fact records may have null value for the dimension key. I created a many to one relation between fact and dim...
I solved the issue by changing the dimension key from null value to empty string and the error went away. Other option that I tried and that worked was to create a dimension record called "Not Applicable" and use that primary key instead of null in the Fact table.
I solved the issue by changing the dimension key from null value to empty string and the error went away. Other option that I tried and that worked was to create a dimension record called "Not Applicable" and use that primary key instead of null in the Fact table.