Forum Discussion

shris19's avatar
shris19
Frequent Visitor
2 years ago
Solved

Data Modeling

Hi Everyone , I am looking for a clarification in data modelling in power BI.

I have two tables i want to build a relationship between.
One is fact table with all the business values and another one is dimension table.

I have one  column in fact table which is named Question_option_field and has Field name values (distinct values - 214, total rows - 19000) and another column in dimension table named Question_option_field for those Field Values
The catch here is that the dimension table column which i want to connect with the  Fact table column has not all the distinct values (so it only has some values of Question_option_field(field names , around 150 distinct and unique value).
When I am trying to create a relationship between them , it is showing me many to many relationship where it should have one to many relationship.
I want to ask is it happening because i dont have aal the distinct values of filed column in the dimension table column or is there some other reason?? Also does it effect my report??


  • Hello shris19 

    this could happen because you have a blank value in the 1-side relationship on the field that the relationship is based on upon . 

     

    if that so, you can replace the blank in power query to #N/A 

     

2 Replies

  • Daniel29195's avatar
    Daniel29195
    Community Champion

    Hello shris19 

    this could happen because you have a blank value in the 1-side relationship on the field that the relationship is based on upon . 

     

    if that so, you can replace the blank in power query to #N/A