Forum Discussion
Issues with Pivot table: Data Model is not applying relationship
Hi there, What I'm trying to do is build a pivot table that utilizes a data model. Unfortunately, for some reason, the relationships described in the data model are not being applied to the pivot...
Hi Royden,
Right tool will be Power Query, please see attached
Thank you Sergi, I took a look at your solution. Does that mean Pivot tables don't work with the data models. I was trying to stay away from a marged table as I have a large data set and would like to leverage data relationships and pivot tables.
Royden, Pivot Table works fine with data model, that's the main method to show data model results.
In your case in one-to-many relationships build pivoting from many to one. To your middle table in Power View add name and role from the related table
and pivot it
Please see attached
- Thank you!
I was running into same exact problem - was able to figure out path forward by studying the PowerQuery steps in your sample file.
