Forum Discussion
HubSpot Data Relationships?
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,
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
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.
Anonymous,
In Power BI Desktop, no matter which method you use to connect to the source, Power BI will automatically establish new relationships/autodetect existing relationships as long as you enable the relationship options.
In your scenario, please share sample data of your tables and post expected result here.
Regards,
LydiaSome 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,
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