Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Matching Error When Relating Tables in Power Query in Power BI

Error:

When relating tables by ID and index in Power BI, a matching error occurs, causing data with different indexes to match while data with the same indexes fail to match.

Inquiry:

How can this problem be resolved? If possible, please provide me with step-by-step instructions.

General Comment
Tips and Tricks
  • Akash_Varuna's avatar
    Akash_Varuna
    1 year ago

    Hi Anonymous It might be due to mismatched data types or inconsistencies in the columns used for the relationship.
    Could you please try these for solving

    1. Match Data Types: Ensure both columns (ID and Index) have the same data type in Power Query.

    2. Trim and Clean Data: Remove extra spaces using "Trim" or Text.Trim().

    3. Check for Duplicates: Remove duplicates in both tables if necessary.

    4. Recreate Index: Ensure index columns are correctly aligned and unique.
      After these please recreate and test the relationship in Power BI.

4 Replies

  • Akash_Varuna's avatar
    Akash_Varuna
    Super User
    1 year ago

    Hi Anonymous It might be due to mismatched data types or inconsistencies in the columns used for the relationship.
    Could you please try these for solving

    1. Match Data Types: Ensure both columns (ID and Index) have the same data type in Power Query.

    2. Trim and Clean Data: Remove extra spaces using "Trim" or Text.Trim().

    3. Check for Duplicates: Remove duplicates in both tables if necessary.

    4. Recreate Index: Ensure index columns are correctly aligned and unique.
      After these please recreate and test the relationship in Power BI.

  • v-achippa's avatar
    v-achippa
    Community Support
    1 year ago

    Hi Anonymous,

     

    Thank you for reaching out to Microsoft Fabric Community.

     

    Thank you Akash_Varuna for the prompt response.

     

    As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the super user resolved your issue.
    If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

     

    Thanks and regards,

    Anjan Kumar Chippa

    • v-achippa's avatar
      v-achippa
      Community Support
      1 year ago

      Hi @changzhe,

       

      We wanted to kindly follow up to check if the solution provided by the super user resolved your issue.
      If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

       

      Thanks and regards,

      Anjan Kumar Chippa

      • v-achippa's avatar
        v-achippa
        Community Support
        1 year ago

        Hi @changzhe,

         

        As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the super user resolved your issue.
        If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

         

        Thanks and regards,

        Anjan Kumar Chippa