Forum Discussion

milkynight's avatar
milkynight
Helper I
4 years ago
Solved

Troubleshooting table relationship issue

Hey guys,   Appreciate your help to solve the problem about the table relationship. In detail, I have 2 tables - A and B - that share a common column named "Store". I link them up by Many to One (M...
Need Help
  • milkynight's avatar
    milkynight
    4 years ago

    Hi v-chenwuz-msft 

     

    I reloaded the excel file and rebuilt the relationship. This time it works and problem is solved, Im not sure why. Thank you anyway!

milkynight's avatar
milkynight
Helper I
4 years ago

Hi v-chenwuz-msft 

 

Thanks for the suggestion. Unfortunately, i have checked several times to ensure that names in both tables are the same. To simplify my check, I changed the name in both tables to be "A" (to make sure the space is not an issue)

Below screenshot of the same problem. They can't sync with each other despite the same name, hence im afraid VALUES may not be helpful neither...

 

 

Do you have any other thoughts on this matter? Many thanks!

  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    Community Support
    4 years ago

    Hi milkynight ,

     

    If possible, please share your pbix file without sensitive data.

     

    Best Regards

    Community Support Team _ chenwu zhu

    • milkynight's avatar
      milkynight
      Helper I
      4 years ago

      Hi v-chenwuz-msft 

       

      I reloaded the excel file and rebuilt the relationship. This time it works and problem is solved, Im not sure why. Thank you anyway!