Forum Discussion
Relationships Not Working when using Analyze In Excel
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...
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?