Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I'm curious how can one handle cyclic dependencies. Let's say we have four tables: Users, Desktops, Orgunits and Tasks. Each Orgunit has some Desktops assigned and some Users working on those devices. Each Task is being executed by a User on a Desktop BUT there is an option that User can from time to time work for another Orgunit on their Desktops. Now we have to maintain all the informations:
So far my model has duplicated Desktop table so there is no cycle but I'd like to avid having the very same table added twice.
This is of course very simplified model of my real situation (I've got some more tables between Users and Tasks and the whole model is not finished yet, might happen that cyclic dependency will pop up again later).
What are your advices? What are the best practices?
Hi @Anonymous ,
I'm not sure if my understanding is correct or not...Do you want to know how to avoid the circular dependency when create the data model(similar with the one in below screen shot)?
Please check if the following documentations can help you:
Adjusting Cross filter direction for a complex set of tables and relationships
What is the Direction of Relationship in Power BI?
Best Regards
Rena
Sorry, not following this. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
@Greg_Deckler, with all respect could you be more specific on what's wrong with my post? I'll try to improve it but I really honestly don't know which point do you find missing/missleading. What point(s) from linked post do you refer to?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |