Power Pivot is not detecting relationship

Hi
I have 3 simple files and I created relationships but when I upload it to Pivot table then to create a report that shows Salary by Dept, I get error message saying No relationship detected. Please see screen shots and files attached. I would appreciate any help. Thank you so much.

Thank you Alan for your help and reply. PP1 file has Name columns and PP2 file has Name column too, So I linked them using Name Column. Then PP2 and PP3 files both have ID column so I liked them using ID columns. So this what I was thinking, PP1 and PP2 are linked via Name Column and PP2 and PP3 linked via ID column then all most be linked now, am I wrong? but also lets forget about PP3 file, I liked PP1 and PP2 using Name column, should not that be enough to get the Salary from the PP2, I only used in my Pivot table Dept column (from PP1) and Salary column from PP2. Why even this one does not work. Thank you once again,

Thank you very much for your reply. I went back and renamed each table, from PP1.xlsx (tablename = Names), from PP2.xlsx (tablename = Salary), from PP3.xlsx (tablename = StartDate) and I created relationships

1) PP1.xlsx and PP2.xlsx (Common column is Name)
2) PP2.xlsx and PP3.xlsz (Common column is ID)

I am attached the main file (all.xlsx) that has the pivot table. I do not know what wrong I am doing? Thank you very much

I changed the order and it is working now. I first selected the Salary table from PP2.xlsx and then the Names table from PP1.xlsx and that creates different "1 to Many" relationship. Please see attached screenshot. Now my question, how can I know which table I should start? and what does 1 to Many means here? Is it one Name to Many Salaries OR one Salary to many Names? Thank you very muchSNAG-0210.jpg

HI
You have fact tables (with items you want to slice the data like department, period, names,..) and data table (with salary, ...)

1 to many means you have a unique list of ID (one for each Name) in your name list. This ID could get a salary every month in your salary table, therefore repeatly showing up every month in the salary table.
Your tables are not in normal form. e.g. salary table contain the age, the phone number is in the date table.
For small DB no issues I guess, but thats not the normalization you should use building a DB.

Looking at your data you only have facts in my opinion. Each table showing some details for one person. In this case you dont need to split the tables, just combine them into one and you are done.

So, depending if this is the final version of your Files, just join them and its fine. If this is a start for a bigger project, follow the normalization rules and build the modell accordingly