In Power BI, a relationship connects columns in different tables and determines how filters travel between them. A sound model usually pairs dimension tables, which help users filter and group data, with fact tables, which hold values to summarize. To diagnose an unexpected visual, check the tables’ roles and grain, relationship keys and cardinality, filter direction, and whether the intended path is active.
What a relationship does in a Power BI model
A relationship is more than a line between tables: it establishes a filter-propagation path. When a report visual uses fields from related tables, that path determines which rows are included in the calculation. If the path is missing, ambiguous, or based on unsuitable keys, a visual can return results that do not match the question being asked.
In a common star schema, dimension tables describe entities such as dates, products, or customers. They support filtering and grouping. Fact tables record events or transactions and contain values to summarize. Microsoft describes the dimension role this way: “Dimension tables enable filtering and grouping.” Microsoft’s star-schema guidance explains these roles and why a consistent fact-table grain matters.
Grain means what one row in a fact table represents—for example, one order line or one daily product total. Keep that meaning consistent within the table. Combining rows at different grains can make a measure difficult to interpret, even when relationships are configured correctly.
Free tools Windows power users keep installed
One-click scans. No signup required.
#1 Best Overall
- Read Before You Buy — No Video Output: These adapters support charging and USB 2.0 data transfer, but cannot transmit video signals. Except for standard USB webcams (which use USB data only), they are not compatible with HDMI/DisplayPort cables, video-capable USB-C hubs, or docking stations with video output.
- Convert USB-A Ports to USB-C: Designed to connect USB-C earphones, cables, flash drives, card readers, and other USB-C accessories to standard USB-A ports. Plug-and-play with no drivers or software required.
- Aluminum Alloy Housing: Built with a sturdy aluminum alloy shell that aids in heat dissipation and protects against daily wear and scratches. Designed to maintain a stable and secure connection.
- Compact & Travel-Friendly: The ultra-compact design allows the adapter to stay plugged into your device without blocking adjacent ports or adding bulk, reducing wear and tear on your original USB ports.
- 12-Month Warranty: Backed by a 12-month manufacturer warranty for peace of mind. Designed to meet strict quality control standards for reliable everyday performance.
How to create and inspect relationships
Power BI Desktop may detect relationships when you load tables, but detection is a starting point, not a guarantee that the model matches your reporting logic. Inspect the columns used as keys and verify that the intended relationship reflects the data. You can create or edit relationships in Power BI Desktop; see Microsoft’s current create-and-manage-relationships documentation for the interface workflow, which may change over time.
- Open Model view. Review the table diagram and locate the line between the tables. Microsoft documents the view at Model view in Power BI Desktop.
- Check the columns at each end. Confirm that they represent the same kind of key and that values match as intended. A relationship between columns with different meanings or incompatible values will not create the intended filter path.
- Check uniqueness and repeats. For a one-to-many relationship, the one-side key must be unique. If duplicates appear on a column that must be unique, refresh can fail.
- Read the relationship indicators. In Model view, the line indicates cardinality and arrowheads indicate filter direction. Confirm they reflect the intended relationship rather than changing settings to make a visual appear plausible.
- Check active status and the filter path. When more than one relationship is available, determine which is active for normal reporting and whether another path could make filtering ambiguous.
For a fuller explanation of relationship behavior and indicators, see Microsoft’s relationship concepts documentation.
Rank #2
- 5-in-1 USB-C Hub: Experience comprehensive connectivity featuring a Power Delivery input, two USB-A 2.0 ports, a USB-A 3.0 port, and an HDMI port. (Note: The USB-C power delivery input port is only for connecting an external wall charger to power your laptop and cannot power peripheral devices.)
- 90W Pass-Through Charging: Achieve optimal charging with 90W pass-through power to your laptop, supported by a total input of 100W, with the hub reserving 10W for operational efficiency. (Note: Wall charger not included.)
- Quick Data Transfers: Accelerate your productivity with rapid data transfers using a high-speed 5Gbps USB 3.0 port and two 480Mbps USB 2.0 ports.
- 4K HDMI Display: Enhance your visual experience with a hub capable of delivering 4K resolution at 30Hz in both mirror and extend modes. Please note that this hub is compatible with MacBook (macOS 12 and newer), Windows 10 and 11, ChromeOS, and laptops equipped with DP Alt Mode and Power Delivery. Note: This device is not compatible with Linux.
- What You Get: Anker USB-C Hub (5-in-1, 4K HDMI), welcome guide, 18-month warranty, and our friendly customer service.
What cardinality means
Cardinality describes whether the values on each side of a relationship are unique or repeated. The right choice depends on the actual data, not on which setting seems likely to fix a report.
| Cardinality | What it means | Typical modelling implication |
|---|---|---|
| One-to-many | Values are unique on one side and may repeat on the other. | Commonly connects a dimension’s unique key to a fact table’s repeated foreign key. |
| Many-to-one | The same uniqueness pattern as one-to-many, viewed from the opposite table. | Often describes the fact-to-dimension side of the same connection. |
| One-to-one | Values are unique on both sides. | Use only when the data genuinely has a one-to-one correspondence. |
| Many-to-many | Values may repeat on both sides. | Can support particular data patterns, but needs deliberate design and validation. |
The one-to-many pattern is common because a dimension key identifies one entity while the corresponding value can appear in many fact rows. If that supposedly unique dimension key contains duplicates, resolve the data or modelling issue rather than treating the relationship setting as a substitute for a valid key.
Crashes, No Sound, or Screen Glitches?
Random freezes, missing sound and display glitches usually trace back to one bad driver. Find and replace yours safely.Free scan · under a minuteWindows Errors? Fix Them Before They Spread
Repair common Windows errors and clear accumulated junk for a smoother, more stable PC - no reinstall needed.Free scan · no reinstallRank #3
- Sleek 7-in-1 USB-C Hub: Features an HDMI port, two USB-A 3.0 ports, and a USB-C data port, each providing 5Gbps transfer speeds. It also includes a USB-C PD input port for charging up to 100W and dual SD and TF card slots, all in a compact design.
- Flawless 4K@60Hz Video with HDMI: Delivers exceptional clarity and smoothness with its 4K@60Hz HDMI port, making it ideal for high-definition presentations and entertainment. (Note: Only the HDMI port supports video projection; the USB-C port is for data transfer only.)
- Double Up on Efficiency: The two USB-A 3.0 ports and a USB-C port support a fast 5Gbps data rate, significantly boosting your transfer speeds and improving productivity.
- Fast and Reliable 85W Charging: Offers high-capacity, speedy charging for laptops up to 85W, so you spend less time tethered to an outlet and more time being productive.
- What You Get: Anker USB-C Hub (7-in-1), welcome guide, 18-month warranty, and our friendly customer service.
When to use a many-to-many relationship
A many-to-many relationship can be appropriate when both related columns contain repeated values and the reporting requirement genuinely calls for that connection. It also changes how the model evaluates relationships, so it should not be chosen just because creating a one-to-many relationship is inconvenient.
Consider whether a bridge table makes the relationship logic clearer. A bridge represents the associations between the entities and can make the route through the model easier to understand. Microsoft’s many-to-many relationship guidance covers these patterns and relevant integrity concerns. In some limited-relationship scenarios, integrity issues can cause rows to be omitted; validate that the result represents the intended data.
Rank #4
- Dual Converters, Infinite Potential：Includes 2× USB C male to USB A female adapters and 2× USB A male to USB C female adapters. Perfect for a wide range of uses—tablets with Bluetooth keyboards, expand USB ports on macbook, and more. Two different converters for all your daily needs
- Next-Level 10Gbps & 3A Charging: No more slow 480Mbps, this usb to usb c adapter has a transfer speed of up to 10Gbps, allowing you to do more transferring in less time. This usb adapter fits both USB A and USB C charger, supporting up to 3A fast charging
- Upgraded Exquisite Craftsmanship: With an aluminum alloy housing and metal connector, the usbc to usb adapter is extremely durable and sturdy. Rigorously tested to withstand more than 10,000 times of plugging and unplugging, ensuring long-lasting performance
- Broad Compatible: The usb c to usb adapter widely supports all USB C/ USB A devices like laptops, tablets, cellphones, car chargers, and phone chargers. Such as compatible with MacBook Pro/Air 2023/2022, Thunderbolt 4/3 Devices,Apple MagSafe Watch 9/8/7/SE/Ultra, iPad Pro 2022/2021, Samsung Galaxy S23/S20/S10, and iPhone 17/16/15 Pro. Plug and play
- Please Note: To reach 10Gbps speed, keep the cable under 3.3 ft. For USB A Male to USB C adapters, try flipping the USB C connector. USB C Male to USB A adapters support bidirectional 10Gbps transfer within 3.3 ft
Should cross-filter direction be single or both?
Cross-filter direction determines which way a filter can travel through a relationship. Single-direction filtering is common and helps make the route through a model easier to reason about. Bidirectional filtering allows filters to flow both ways and can meet a specific reporting need, but it is not a general remedy for incorrect totals.
Enabling bidirectional filtering can affect performance or introduce ambiguous paths. That risk matters particularly when a model has multiple fact tables connected through shared dimensions: allowing filters to travel both ways may leave more than one route between tables. Use it only when you can identify the report requirement it satisfies and confirm that the resulting path is unambiguous. See Microsoft’s guidance on bidirectional relationships.
Best Value
- 5-in-1 Connectivity: Equipped with a 4K HDMI port, a 5 Gbps USB-C data port, two 5 Gbps USB-A ports, and a USB C 100W PD-IN port. Note: The USB C 100W PD-IN port supports only charging and does not support data transfer devices such as headphones or speakers.
- Powerful Pass-Through Charging: Supports up to 85W pass-through charging so you can power up your laptop while you use the hub. Note: Pass-through charging requires a charger (not included). Note: To achieve full power for iPad, we recommend using a 45W wall charger.
- Transfer Files in Seconds: Move files to and from your laptop at speeds of up to 5 Gbps via the USB-C and USB-A data ports. Note: The USB C 5Gbps Data port does not support video output.
- HD Display: Connect to the HDMI port to stream or mirror content to an external monitor in resolutions of up to 4K@30Hz. Note: The USB-C ports do not support video output.
- What You Get: Anker 332 USB-C Hub (5-in-1), welcome guide, our worry-free 18-month warranty, and friendly customer service.
Active and inactive relationships
An active relationship supplies the default filter path for reporting. An inactive relationship remains available for specific calculations, but it does not replace the active path automatically. Where tables have multiple potential connections, decide which one should be the default and keep the model’s filter paths deterministic. For details on the distinction and its use, consult Microsoft’s active-versus-inactive relationship guidance.
A practical way to investigate an unexpected visual
There is no single fix for every incorrect total: the cause may be the data, the model, the filter route, or the calculation. Work through the model before changing filter direction.
Quick Recap
- Confirm what each row represents. Check that fact-table grain is consistent and that the measure summarizes the intended rows.
- Verify the relationship keys. Ensure the columns refer to the same entity or key, and inspect whether the one-side column is actually unique.
- Confirm cardinality. Compare the real uniqueness and repetition patterns with the relationship setting.
- Trace filter direction. Follow the arrowheads in Model view and check whether the fields in the visual can filter the relevant fact rows along that route.
- Check active status and alternative paths. Establish which relationship Power BI uses by default and whether another connection could produce ambiguity.
- Choose a modelling change only for a demonstrated need. Depending on the data, that might mean correcting a key, clarifying the model with a bridge, changing the intended active path, or enabling bidirectional filtering for a specific requirement.
- Recheck the visual against the intended result. Test representative filters and values so the change fixes the reporting logic rather than merely changing the displayed number.
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
