cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Controlling the Analyze in Excel Drill-through

 

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)?

3 REPLIES 3
Super User II
Super User II

Hi there

Currently there is no way to automatically control what gets seen from Power BI. When a user double clicks it returns all the rows from the underlying table.

You could try and hide the columns (That might work)




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

 

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.

Could it be that you hid some columns?

Or for the Export Data Option you changed the settings?




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Microsoft Ignite

Microsoft Ignite with Arun Ulag

Featured Session: Drive Data Culture with Power BI- Vision, Strategy & Roadmap. Register here https://myignite.microsoft.com #MSIgnite #PowerPlatform #Power BI ​

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors