Skip to main content
Microsoft Idea

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

Patrick on 16 Aug 2020 04:01:04

RE: See Records feature improvements

Being able to edit the columns and have those edits stick is important. Myself and our users can edit what columns they see but there is no way to control the columns that show up from the start.

This is a must have.

Kien's profile image Profile Picture

Power BI User on 16 Aug 2020 04:00:27

RE: See Records feature improvements

In addition to the three points - I force a graph to show all months on x axis even when half way through a year even though there is no data in later months by using the "show items with no data" (I have a linked table with months). However, by doing this the "See Records" function fails as we get a error message saying "We cannot display the detailed records table for this data source without a unique key". Please amend this so records can be shown for those months / axis point that are there.

Kien's profile image Profile Picture

Saravanan on 16 Aug 2020 03:59:32

RE: See Records feature improvements

Please bring this in next update. At lease #2.

Kien's profile image Profile Picture

Power BI Ideas Admin on 16 Aug 2020 03:59:29

RE: See Records feature improvements

#3 would be super-important! It (ie. turning off See Records) would highly improve usablity of PBI in vizualising sensitive data, like survey data where each row represents answers of single individual.

The "data validation" - argument on nescessity of See records -function is inadequate. The one who creates PBI-report needs to be aware of the level of data validity and act accordingly. In See records -function does not actually ensure the data validity for end user at any level. The data can be false despite of the row level visibilty.


Kien's profile image Profile Picture

Aggie on 16 Aug 2020 03:59:23

RE: See Records feature improvements

same problem - can't share a report because of the sensitive data on which the report is based on

Kien's profile image Profile Picture

Andrew Fitzgerald on 16 Aug 2020 03:59:08

RE: See Records feature improvements

Just ran into this issue. I'm trying to share a public report, but now I can't because confidential information is accessible just by clicking on "see records"

Kien's profile image Profile Picture

Power BI User on 16 Aug 2020 03:59:07

RE: See Records feature improvements

Most users do not want to share the underlying data. users should have an easy way to turn off the feature 'See Records'

Kien's profile image Profile Picture

Tas on 16 Aug 2020 03:59:07

RE: See Records feature improvements

Definitely required to enable users to understand basis of calculated measures.

Kien's profile image Profile Picture

Power BI User on 16 Aug 2020 03:58:56

RE: See Records feature improvements

#2 is critical

Kien's profile image Profile Picture

Sujata.Mehta on 16 Aug 2020 03:58:06

RE: See Records feature improvements

Additionally, the ability to individually turn on/off columns that would be displayed in the “See Record” option would be very useful. Often we have hundreds of columns in the dimensions and would be helpful to turn on just a selected set of columns for display.