So Management wants to keep using Pivots (and the underlying data in tables) in Excel.
I have made some datasets in PBI and they were published to the workspaces in the PBI service. Then I did the Analyze in Excel and I made some pivottable reports that are connected to these datasets. So far so good.
Now if I drillthrough (doubleclick) on let’s say the grand total of the pivottable, Excel opens a new sheet that contains the “raw data” of that total (more or less, because of the measure used in the pivottable was distinctcount, then it allso includes the doubles in the “raw data”).
Problem is that the “Raw data” doesn’t seem to include the columns that I used to build the relationships in the original dataset (ex. postalcode in the Factsales table wont show in the drillthrough data of total sales, because postalcode has a relationship with DIMTABLE “Adress”. I use some dimensions of this Dimtable Adress on the rows of the pivottable).
Is this a know issue in Excel/Analyze in Excel ?
Can I solve this with an option somewhere ?