Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Relationships Not Working

Hi,


I created a separate table with the same values as two other tables in my dashboard but they won't connect and i am not sure why.

 

Column 1 contains the same values as customer in 3 of the other tables.

 

 

Kind regards


Dominic

25 Replies

  • Have you tried creating the relationship manually? If so could you send a screen shot of the error you are getting?

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee

    Hi Anonymous,

     

    Maybe you need to establish relationships manually. It can be created automatically. But the "auto relationship" can't detect the relationships all the time.

     

    Best Regards,

    Dale

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thanks Dale, but I am not sure how to do this?

       

      Kind regards

       

      Dominic

      • v-jiascu-msft's avatar
        v-jiascu-msft
        Microsoft Employee

        Hi Dominic,

         

        1. You can drag the field from one table to the other table with the left button of the Mouse.

        2. You also can follow the function "Manage Relationships".

        Relationships_Not_Working

         

         

        Best Regards,

        Dale

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee

    Hi Anonymous,

     

    Could you please mark the proper answers as solutions?

     

    Best Regards,

    Dale

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi Dale,

       

      It hasn't worked unfortunately, I already tried the suggested solutions before and it wasn't connecting and came up with the errors shown in the previous screenshots.

       

      The data is exactly the same, I even created a table with one column with the exact same data and it still wouldn't connect?

       

      Kind regards


      Dominic

      • v-jiascu-msft's avatar
        v-jiascu-msft
        Microsoft Employee

        Hi Anonymous,

         

        Can you share the file? You can mask or delete sensitive parts first.

         

         

        Best Regards,

        Dale