Relationships Not Working when using Analyze In Excel

[Anonymous]

The relationships of tables in Power BI are not coming through for the pivot table I am trying to create in Analyze In Excel. I read a post about this situation here that suggested relationships work when using Measures, but I am trying to create pivot table showing Project Name and Project Owner from a Project table, tied to Project Tasks from a Tasks table, the two being linked One to Many from Projects to Tasks based on ProjectID. The link from the previous post that was supposed to help understand this is no longer working. Help!

[Anonymous]

You say that, and I believe you, but when I put ProjectID from the Project Table (basically, the dimensions table) as rows, then put ProjectName from the Project Table, also as rows, so far so good. But, to test it, I then bring in ProjectName from the Tasks Table (fact table), also as rows, which is linked to the Project Table via ProjectID, and what I end up with is a pivot table with number of Project Names squared rows. So, what am I missing?

[lbendlin]

Relationships work the same way as they do in Power BI. You will want to be careful which side of the relationship you pick your key field from (for example Project ID if that is your linking field) - from the dimension table (recommended) or from the facts table (if absolutely necessary). If you want to see the same behavior as in Power BI then you should check which side was chosen there.