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

[SurendraD]

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 

[v-yifanw-msft]

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.