To produce the fresh dating
In the Create matchmaking, pick New to open new Perform matchmaking dialog package, where we are able to select the dining tables, columns, and you may any extra configurations we want for the relationships.
In the first miss-off listing, find ProjectHours due to the fact first dining table, next discover the Investment line. That it top is the of many edge of our matchmaking.
About 2nd shed-off listing, CompanyProject was preselected since the next desk. Find the ProjName column. Which https://datingservicesonline.net/tagged-review/ front is certainly one edge of our matchmaking.
For the sake of complete revelation, you just authored that it dating the hard method. You can get only selected Autodetect on Manage relationships dialogue container. Indeed, autodetect might have immediately created the dating for you once you loaded the details in the event that both articles had the same identity. However,, what’s the complications for the reason that?
Once we summarize hours because of the Concern, Fuel BI Desktop computer looks for the instance of exclusive color philosophy on the CompanyProject research dining table, looks for all instance of every one of those individuals opinions from the ProjectHours desk, then works out a sum total for every single novel value.
Knowledge additional options
Whenever a romance is created, often with autodetect otherwise you to definitely you make manually, Power BI Desktop instantly configures other choices based on the study on the dining tables. These types of a lot more matchmaking options are found in the down percentage of the newest Manage dating and you will Change relationships dialogue packets.
Electricity BI generally set these selection immediately and you will not need to adjust him or her; yet not, there are some situations where you may want to arrange such choice yourself.
Automatic relationships standing
You can manage how Energy BI snacks and you may automatically changes matchmaking on your own accounts and you will designs. So you’re able to identify how Energy BI protects matchmaking alternatives, come across File > Options and you can setup > Possibilities from Stamina BI Desktop, following discover Study Load from the left pane. The choices getting Dating appear.
Import matchmaking from analysis offer with the earliest load: This one is selected automagically. If it is chosen, Electricity BI checks to own matchmaking defined on the data source, eg foreign secret/no. 1 key relationship on your own investigation factory. If eg relationship exists, they’re shown into Energy BI data design when you initially weight research. This one enables you to quickly take effect together with your model, in the place of requiring you find or describe those people matchmaking your self.
Revise or delete dating when refreshing investigation: This is actually unselected by default. For folks who see they, Electricity BI inspections getting alterations in databases matchmaking in case the dataset is renewed. If those matchmaking altered or is eliminated, Stamina BI decorative mirrors people changes in its investigation design, upgrading or removing them to meets.
If you find yourself having fun with row-height shelter you to utilizes the fresh defined relationship, we do not highly recommend looking for this 1. For many who reduce a romance that your RLS options trust, your design you are going to getting shorter safer.
Typically, Energy BI Desktop computer can also be instantly influence a knowledgeable cardinality towards the relationship. If you must override the latest automatic form, since you know the study will vary in the future, you can change it with the Cardinality manage. Let us view an example where we must look for an effective additional cardinality.
The CompanyProjectPriority table try a summary of most of the providers tactics and you may their priority. The latest ProjectBudget table ‘s the selection of strategies which a great funds has been accepted.
When we manage a love within Approved Ideas line within the the ProjectBudget dining table as well as the ProjectName line regarding CompanyProjectPriority table, Electricity BI automatically set Cardinality to 1 to one (1:1) and you can Get across filter out guidance to Each other.