Forum Discussion
Connecting Tables for Marketo
Joining the fields together, once you know how, is quick. :)
In the diagram view, drag one field from Table 1, onto one field from table 2. To customize the connection, double click or right click on the resulting line between the tables.
I would imagine the ID field in the leads table would be your primary key and the mktoID fields in the other 3 tables would be your foreign keys.
The PowerBI tutorials found at:
https://powerbi.microsoft.com/en-us/guided-learning/?WT.mc_id=PBIService_GetData
are a great way to get started.
Joining the fields together, once you know how, is quick. :)
In the diagram view, drag one field from Table 1, onto one field from table 2. To customize the connection, double click or right click on the resulting line between the tables.
I would imagine the ID field in the leads table would be your primary key and the mktoID fields in the other 3 tables would be your foreign keys.
The PowerBI tutorials found at:
https://powerbi.microsoft.com/en-us/guided-learning/?WT.mc_id=PBIService_GetData
are a great way to get started.
Thanks so much! I tried this and you're correct - Leads should be the primary table. Thanks again!