Analyze in Excel - issue with data pivottable drilltrough

[Martin_How]

Hi guys, 

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

Is this a know issue in Excel/Analyze in Excel ? 

Can I solve this with an option somewhere ? 

Kind regards

[Martin_How · Accepted solution]

Ok gues I found a post on Stackoverflow from 2017 that solved it...

just insert a calculated column that duplicates the column used in a relationship.