Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

HubSpot Data Relationships?

 Hello, I have just gotten an ODBC connector to connect our HubSpot data to Power BI.  It is working just fine and I can see all of the tables, but I have no idea how the associations between tables ...
  • Anonymous's avatar
    Anonymous
    7 years ago

    Anonymous,

    You can split the Associated Contacts column in Power BI Desktop query editor, then create relationship using Associated Contacts column of Deals table and ID column of Contacts tables.


    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Some records will list off their associations all in one box using semicolons, which makes data difficult to connect in Power BI.  For instance, the single ID's will match since it is a single reference but when a cell is filled in with multiple ID’s it will not.  How do I make this kind of data match up?

 

Deals

  

Contacts

 

Name

Associated Contacts

 

ID

Name

Deal 1

443059; 249950; 192529

 

443059

John Smith

Deal 2

443059

 

249950

Jane Doe

Deal 3

249255

 

192529

Ozzy Osbourne

Deal 4

249950; 420955

 

420955

Eddie Van Halen

   

249255

Slash

 

 

 

 

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Anonymous,

You can split the Associated Contacts column in Power BI Desktop query editor, then create relationship using Associated Contacts column of Deals table and ID column of Contacts tables.


Regards,
Lydia

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Ok that works.  The next problem is that when I run reports off of these records they show up as duplicates.  How do I make the reports deduplicate by the unique ID?

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Anonymous,

      Please open a new thread describing the above issue and please share screenshot and sample data in the new thread.

      Regards,
      Lydia