Forum Discussion
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,
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
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,
Please open a new thread describing the above issue and please share screenshot and sample data in the new thread.
Regards,
Lydia