Forum Discussion
Linking two data tables without a common field
Hi all
I have an existing PBIx staff dashboard that covers general employee metrics, plus absence, turnover etc.
I have now been asked to add in an additional section that focuses on our employee training compliance. To that end I have added the Learning data table that comes from our HR system. I have managed to link the "People" data table with the "Learning" data table so that a table will show all the courses completed next to the employee name.
So to get to my question, I have attempted to bring in in the Unit Structure data so that I can organise compliance data by our reporting units. With the existing dashboard visuals there is an obvious link to join tables together, PersonKey, PositionKey, UniStructureKey, but with the new section when I try and add in Unit Structure data I am presented with an error asking me to fix the link between the Person data and Learning data. Unfortunately there is no common field that links the two together.
So I am ideally looking for suggestions on how to link these together (if its possible) so that I can create an expanded dashboard that includes learning information.
(At present DimUnitStructure links to FactWorkForceMonthly (via UnitStructureKey) and that then connects to DimPerson (via PersonKey))
Please let me know if you require further ifnromation, and apologies for the long post.
Hi Andy2410
Is it possible to share the semnatic model that you currently have with the relationships built?It will be easier to understand the issue.
3 Replies
- v-menakakotaCommunity Support
Hi Andy2410 ,
Thanks for reaching out to the Microsoft fabric community forum.Just checking in to see if you were able to review the suggestion shared by Pragati11 . Could you please share your semantic model or confirm if you’re still facing the issue? That will help us understand the relationship setup better and suggest the right approach.
Best Regards,
Community Support Team- v-menakakotaCommunity Support
Hi Andy2410 ,
Can you please confirm whether the issue is sorted or not.
Thank you.