control fields in Analyze in Excel

[Anonymous]

Hi,

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 in the result set, it seems to give them a random selection of columns... most of which are IDs I don't want them to see, some of the columns they do want to see are missing. Where can we add the columns with data (not IDs) so that the user sees while drill down in analyze in excel.

How can I control what the drill-through displays (in excel from a powerbi dataset)?

[amitchandak]

@Anonymous , can you share some screenshot of the issue

[Anonymous]

Hi,

When you click on the number -155584 under the Januar column, a new sheet opens in the excel.

And shows the fields you see, BilagsType, Bilagsnr, arperiodid, etc. This is not a relevant data as such for the customer. How do we control what fields can be shown here? Where is it picking the fields from?