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)
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.
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.
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!
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.
RE: See Records feature improvements
No word from Microsoft on this basic functionality?
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.
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!
RE: See Records feature improvements
Related Idea: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15090138-see-records-column-setup
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!
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.