Forum Discussion
Multiple relationships: systemuser in Dynamics - Created By on multiple tables
Hi everyone, I've imported Dynamics data into Power BI via Dataverse. One of the tables is 'systemuser', which contains all users with their names, IDs, etc. Other tables like 'account', 'cont...
Kedar_Pande
Super User
Super UserInstead of directly linking the systemuser table to multiple tables (like account, contact, etc.), you can create a bridge table for the user IDs. This avoids relationship loops and allows a single username filter to work across visuals.
UserBridge = DISTINCT(SELECTCOLUMNS(systemuser, "UserID", systemuser[systemuserid], "UserName", systemuser[fullname]))
💌 If this helped, a Kudos 👍 or Solution mark ✔️ would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn
Hi Kendar,
Thanks for your reply. Could you explain this more into detail?