Forum Discussion

Vishman's avatar
Vishman
New Member
5 years ago
Solved

Relation issue

Hi All,

 

I want to add a field from a Table to Values, however I get an error 'Can't determine relationships between the fields'. I have no idea what I should be doing, can someone guide me please? I am very new to Power BI.

 

Thanks,

Vishal  

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Vishman,

    You can create a new blank query table and use 'Query Table' name and [field name] to extract the specific field of the query table.

    let
    Source=Table1[Name1]
in 
    Source

    Reference link:
    Operators - PowerQuery M | Microsoft Docs

    Regards,

    Xiaoxin Sheng

4 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    5 years ago

    Hi, Vishman 

    If it is OK with you, please share your sample pbix file's link here.

    Then I can try to look into your problem.

    Thanks.

     

    Hi, My name is Jihwan Kim.

    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

  • HarishKM's avatar
    HarishKM
    Super User
    5 years ago

    Vishman  Hey Man,
    You can go to power query then select that coloumn and add that a query then remove duplicate then convert it as a table and bingo .  you will unique record in new table .

     

     

    Final result will be 

     

    • Vishman's avatar
      Vishman
      New Member
      5 years ago

      Hi Harish,

       

      I tried your steps but I got the same result, when I tried adding the column.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Vishman,

    You can create a new blank query table and use 'Query Table' name and [field name] to extract the specific field of the query table.

    let
    Source=Table1[Name1]
in 
    Source

    Reference link:
    Operators - PowerQuery M | Microsoft Docs

    Regards,

    Xiaoxin Sheng