In this video, Allison Gonzalez from Pragmatic Works discusses the updates made to Power BI's modeling view, specifically the new pop-up screen that appears when building relationships between tables. These changes were introduced in the May 2024 update, which added a more detailed and interactive experience for managing data relationships. Alison walks viewers through the new features and explains why they improve the modeling process.
Previously, when creating relationships in Power BI, users could simply drag and drop columns between tables to build relationships. The new update now introduces a pop-up window that gives users more control and visibility over the relationships they are creating. This window displays the specific columns being connected, the type of relationship (e.g., one-to-one, many-to-one), and options to activate or deactivate the relationship. Alison highlights how this change makes it easier to ensure the correct columns are being linked, which is especially helpful for users who may accidentally connect the wrong fields.
The "Manage Relationships" window has also been revamped. It now includes more buttons and a cleaner interface, allowing users to easily view all existing relationships between tables. Users can now create new relationships by selecting the fact table and the related table, and Power BI automatically identifies potential connections based on key columns. Additionally, a new "Auto-Detect" feature can quickly find relationships between tables, saving users time and effort in complex models.
One of the new features allows users to activate or deactivate relationships directly from the "Manage Relationships" window or the properties pane. This is particularly useful when avoiding circular logic in data models. The update also introduces filter options within the "Manage Relationships" window, allowing users to quickly filter relationships by their type (e.g., one-to-one, many-to-one) or by cross-filter direction. This helps users manage complex models more effectively.
Although the extra pop-up window when creating relationships might initially seem like an extra step, Alison emphasizes that it’s a useful fail-safe to ensure accuracy. For users familiar with Direct Query, these updates may feel familiar, but the added functionality and improvements in the interface make it a valuable update for all Power BI users. These updates enhance the relationship-building experience and provide more flexibility for managing complex data models.
Don't forget to check out the Pragmatic Works' on-demand learning platform for more insightful content and training sessions on Power BI and other Microsoft applications. Be sure to subscribe to the Pragmatic Works YouTube channel to stay up-to-date on the latest tips and tricks.