Relationships are not working properly in Pivot Tables using a data model

[Deleted]

Hi team,

I think I may have found a bug in the latest versions of Excel 365. I built a robust model in PowerPivot in Excel 2013 using many different relationships, and have created pivot tables before using the model, and relying on those same relationships between my tables. However, this week I tried creating a new pivot table, and the relationships were no longer working. My first suspicion is that an update to Office 365 broke some of that functionality. My model also had calculated columns using the RELATED function that started returning errors everywhere. Thankfully my cube formulas in the front end and the slicers are still working as far as I have checked, and I was able to switch from the RELATED function to the LOOKUP function.

Has anyone else experienced a similar issue? Are you able to create a pivot table from your data model using existing Relationships with no issues?

Thank you for the insight, and I hope we can get this resolved quickly.