Skip to main content

Power BI

Needs Votes

See Records feature improvements

Vote (740) Share
Kien's profile image

Kien on 27 Jul 2016 08:00:23

The 'See Records' feature is a great feature but is not complete. It needs to be able to

1. Be used with all types of visuals (charts, tables, matrix, custom visuals)
2. Compatible with Calculated measures
3. Allow for feature to be turned on or off for each individual visual

Comments (93)
Kien's profile image Profile Picture

Power BI User on 16 Aug 2020 04:02:33

RE: See Records feature improvements

Would also propose a variant of #3. Allow a limit to be set for the number of records that can be viewed. In many cases allowing someone to view or copy the entire dataset has to be prevented but not necessarily allowing someone to view or copy a few individual records. So configuration functionality to allow users to drill down and see a few records while restricting bulk record viewing would be helpful.

Kien's profile image Profile Picture

Power BI User on 16 Aug 2020 04:02:24

RE: See Records feature improvements

I desperately need this feature to be fixed. This is pretty ridiculous to have to edit the See Records every single time I need to see a date column.

Kien's profile image Profile Picture

Power BI User on 16 Aug 2020 04:02:24

RE: See Records feature improvements

All of a sudden every dimension I have comes across in the See Records and the assistance I got from the help desk was to un-click the fields .... that defeats the purpose for the business users .... there needs to be a way to setup the desired number of columns during the setup of the dashboard. PLEASE!

Kien's profile image Profile Picture

Kamil Cholewka on 16 Aug 2020 04:02:12

RE: See Records feature improvements

Not only has it been requested for over 2 years, it looks like PowerBI team hasn't even acknowledged the need of this. Ridiculous. There HAS to be a way to save the setup of desired columns so that you don't have to manually arrange it everytime you come back to See records.

Kien's profile image Profile Picture

J Michael Williams on 16 Aug 2020 04:02:07

RE: See Records feature improvements

No word from Microsoft on this basic functionality?

Kien's profile image Profile Picture

Brandon Pereira on 16 Aug 2020 04:02:05

RE: See Records feature improvements

I can see the validity of all three but #2 may be a deal breaker for me. Seems like this would be a basic capability since it is already included in PowerPivot. Unfortunately I may have to switch my reporting to Tableau because of this issue.

Kien's profile image Profile Picture

Chris99 on 16 Aug 2020 04:02:02

RE: See Records feature improvements

Definately required. As it currently stands "See Records" seems great, but you soon find out how incomplete the implementation is.

As well as hiding, moving column, the ability to add columns from the same table(s) used in the visual is a requirement. For example I have a table with a measure based on a date field, but I can't see the date field in "See Records". Go figure!

Kien's profile image Profile Picture

Joel Faltermeier on 16 Aug 2020 04:01:48

RE: See Records feature improvements

Related Idea: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15090138-see-records-column-setup

Kien's profile image Profile Picture

Thomas Mulvey on 16 Aug 2020 04:01:13

RE: See Records feature improvements

As pointed out in a post on the community forum, you can exploit this flaw to see the names of individuals in an otherwise anonymous chart. There's even an example *promoted by Microsoft's own BI blog* showing charity beneficiaries on the chart 'number of projects by area', here:
https://app.powerbi.com/view?r=eyJrIjoiZTM5ZDc1ZGQtNDEyNy00OGNkLTk2MzctNGExOWQ5NTQyYjUwIiwidCI6Ijg3ZjhjYWY0LWJhZDktNGQxMS1iOGU2LWYxNTVkOWIxMmFjOSIsImMiOjZ9

This needs a fix!

Kien's profile image Profile Picture

Power BI User on 16 Aug 2020 04:01:06

RE: See Records feature improvements

Number three would be particularly valuable. I work in a public agency with highly sensitive data - not being able to turn it off really limits how widely I can share.