Power BI Table Relationship Detector
Upload 2 or more of your real CSV/Excel files — this checks which columns actually link them, how (one-to-many, one-to-one, or a risky many-to-many), and flags tables that don't share anything at all.
| Table A | Table B | Linked by | Relationship | Confidence |
|---|
How this works
This doesn't guess from column names alone. For every pair of files you upload, it compares the actual values in each column — if most of the values in one file's "CustomerID" also show up in another file's "CustomerID", that's a real, evidenced link, not just a naming coincidence. It also checks which side is unique (the "one" in a one-to-many relationship) so you know which table is your lookup/dimension table and which is your transaction/fact table.
Why "many-to-many" is a warning, not just a label
Power BI relationships work best when one side of the link is unique. If neither side is — say, two files both list the same TeamID more than once — Power BI either won't let you create the relationship directly, or it will, and your totals will double-count. The fix is almost always a third, smaller lookup table in between.
A worked example
Upload customers.csv (CustomerID, Name) and orders.csv (OrderID, CustomerID, Amount). CustomerID is unique in customers.csv but repeats in orders.csv — so this reports customers (one) → orders (many) with strong confidence, exactly the relationship Power BI's own model view would want you to draw.
Questions
Is this free?
Yes, completely free, no account or signup needed.
It says no relationships were found — what now?
Check that your key columns actually match between files — a leading zero, extra space, or one file storing an ID as text and another as a number are the most common reasons a real link doesn't get detected. Fix the formatting in one file and try again.
How many files can I check at once?
Up to 6 files in one go, 4MB total across all of them.
Is my data stored anywhere?
No. Your files are read once to compute the relationships shown and never retained afterward.
Is there a tool that explains star schema design in general?
Yes — the Star Schema Explainer walks through the concept with a worked example. This tool checks your own actual files instead.
Relationships look right? Build the dashboard now.
Upload your files, describe what you want, and get back a real, editable .pbip project — free, no Fabric or Copilot license needed.
More free tools: star schema explainer · data profiler · combine CSV files · see all →