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...
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.