Forum Discussion

SurendraD's avatar
SurendraD
Frequent Visitor
2 years ago

Errors while building the relation ship between Direct connected module and imported excel

Hi All,

I am trying to build relationships between direct connected module with imported excel module. but I am facing some erros while building.

FOD is direct conection 
Invoices is imported 

relation broking:

 

 


Requesting to all please help me to fix this 

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi SurendraD ,

    From your description, it appears that you are encountering errors when trying to establish these relationships. Here are some steps that may help resolve the problem:

    1. Ensure that the columns you are trying to relate to have matching data types and that both columns have corresponding values. Mismatched data types or missing values may prevent the relationship from being established.
    2. You are working with a complex data model, make sure that the structure of your model supports the relationship you are trying to create. Refactoring the model or using bridging tables can resolve relationship issues. For more insights on data model relationships, this article may be helpful:
      Create and manage relationships in Power BI Desktop - Power BI | Microsoft Learn

    I also recommend that you read the following documentation, which may be helpful in solving your problem:
    Composite model guidance in Power BI Desktop - Power BI | Microsoft Learn
    Model relationships in Power BI Desktop - Power BI | Microsoft Learn

     

    Best Regards,

    Ada Wang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.