
On the Modeling tab, select Manage relationships > New. On the Modeling tab, select Manage relationships > Autodetect. However, you can still use the Manage relationships dialog box to manually create or edit relationships. If Power BI Desktop can't determine with a high level of confidence there's a match, it doesn't create the relationship.


If there are, those relationships are created automatically. Power BI Desktop looks at column names in the tables you're querying to determine if there are any potential relationships. The relationship options Cardinality, Cross filter direction, and Make this relationship active are automatically set.

If you query two or more tables at the same time, when the data is loaded, Power BI Desktop attempts to find and create relationships for you. Either way, it’s important to understand relationships in Power BI Desktop and how to create and edit them. However, sometimes you might have to create relationships yourself, or need to make changes to a relationship. In most cases you won’t have to do anything. Relationships between those tables are necessary to accurately calculate results and display the correct information in your reports. Note that multi-frame actions cannot be undone, so it's a good idea to save the animation beforehand just in case the result does not match expectations.When you have multiple tables, chances are you'll do some analysis using data from all those tables.

When moving figures or the virtual camera, the new pose in the selected frames will be offset by the amount moved so that they keep their positions relative to each other. Figure based actions are applied only for figures with the matching ID (which is shown in the info bar at the bottom of the screen for the selected figure). Select Yes to complete the multi-frame action or No to only apply the action to the frame being edited. If any of these actions are performed while multiple frames are selected then a message box will appear to ask if you would like to apply the change to the selected frames. This includes paste figures, paste camera, move figures, pose camera, delete figures, set figure colour, set figure transparency, set figure scale, raise / lower figures and join / unjoin figures. Other actions can also be performed on multiple frames to save time.
