Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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.
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.