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

Anonymous,


Could you please post detailed error message here? There is a similar thread about how to handle relationship in Power BI for your reference.

Besides, the reault you want to get can be calculated using DAX, please share sample data of your tables here and post your desired result based on sample data. Please review this post about how to share data.

Regards,
Lydia

Anonymous's avatar
Anonymous
Not applicable
7 years ago

I was just hoping someone here had used the HubSpot API to get data out in their table format so I could see how they had connected their data.  It is quite confusing how the tables work.