In order to make the new relationships
Inside Do dating, pick Not used to discover the fresh new Create matchmaking dialog field, where we are able to discover the dining tables, columns, and any extra settings we truly need for the relationships.
In the first drop-off record, pick ProjectHours once the basic dining table, following get the Endeavor column. So it front side ‘s the many side of our very own relationships.
On the 2nd shed-off number, CompanyProject was preselected because the next table. Discover the ProjName column. Which front is the one side of our very own dating.
For the sake of complete revelation, you merely composed that it matchmaking the tough method. You could have only chose Autodetect on the Do dating dialog box. Indeed, autodetect would have immediately created the dating for your requirements when you stacked the content when the each other articles had the same identity. However,, what’s the difficulties where?
Whenever we sum up circumstances from the Concern, Stamina BI Desktop computer searches for all of the exemplory instance of exclusive colour beliefs regarding the CompanyProject search desk, searches for every exemplory instance of every one of the individuals viewpoints regarding the ProjectHours dining table, following exercises a sum total per unique worth.
Skills other options
When a romance is established, either having autodetect otherwise you to definitely you create manually, Power BI Desktop automatically configures additional options according to research by the research on your tables. Such more dating options are found in the lower part of this new Carry out matchmaking and you may Change matchmaking dialog packets.
Power BI normally sets this type of solutions automatically and you also will not need to regulate him or her; yet not, there are numerous times when you may want to arrange these types of choice on your own.
Automatic relationships status
You can perform just how Fuel BI snacks and you will automatically changes matchmaking on the account and you can patterns. So you’re able to specify exactly how Power BI handles relationship solutions, find Document > Choice and you can setup > Choice away from Fuel BI Desktop, immediately after which get a hold of Study Weight on the kept pane. The choices to own Dating appear.
Transfer relationship away from studies source toward very first stream: This is chosen automagically. When it’s selected, Energy BI checks getting matchmaking defined in your data source, including overseas key/number 1 trick dating in your studies factory. If the particularly relationship exist, they truly are shown to your Stamina BI data model when you first weight research. This 1 makes you rapidly start working with your model, instead of demanding the truth is or define men and women dating oneself.
Update otherwise remove dating whenever energizing studies: That one is unselected automatically. For individuals who pick they, Stamina BI checks getting changes in data source relationship in case your dataset was renewed. If people matchmaking changed or are removed, Electricity BI mirrors those alterations in its very own investigation design, updating or removing them to match.
If you find yourself playing with row-level safeguards one utilizes brand new outlined dating, do not suggest wanting this option. For those who remove a romance that your RLS options believe in, their model you are going to be smaller safer.
Typically, Electricity BI Desktop computer can immediately dictate the best cardinality on relationship. In the event you need bypass the newest automatic means, since you understand the study will be different in the future, you might turn it for the Cardinality control. Why don’t we look at an example in which we have to see good more cardinality.
The latest CompanyProjectPriority dining table is actually a list of the business projects and you may its consideration. The fresh new ProjectBudget desk is the set of tactics by which a great finances could have been accepted.
When we manage a relationship involving the Recognized Tactics line into the the new ProjectBudget desk and ProjectName line on the CompanyProjectPriority desk, Power BI instantly set Cardinality to just one to at least one (1:1) and you may Cross filter assistance so you’re able to Both.