How can I control the fields/columns that are displayed to the user when the user is using the "Analyze in Excel" feature? They successfully connect to the report, they click on the analyze in excel which works, but when they use the pivot table and double click on an entry, it seems to give them a random selection of columns... some of which are IDs I don't want them to see, some of the columns they do want to see are missing.
How can I control what the drill-through displays (in excel from a powerbi dataset)?
It used to display everything... and then I pushed something and now it only displays a few versus everything. I was thinking... great, I managed to find the right button, but I can't remember where that button is because now it displays too few columns.