Forum Discussion
Where are the "see records" columns setup?
Hi,
When I right-click on a visualization report, I get the "see records" option, I click on it, and I get the right number of records but a column that I'd like displayed as well, is not showing, I can add it while being in the "see records" section, but once I click on "back to report", then it's gone.
I reviewed the table's definition and it's including it. How can I add a column in that section and make it stay? where is the "see records" setup?
Thanks a lot!
Brenda
68 Replies
- AnonymousNot applicable
Hanging out for this to be implemented. At the very least, just the ability to save the "See Records" view preferences (column order and visible columns), on a per table level.
- AnonymousNot applicable
Bump
- boovdaFrequent Visitor
BUMP! Can we get a fix pleeeeeeeease???
- AnonymousNot applicable
Hello... Microsoft... your customer base has been asking for a fix for this for more than three years now. Anybody out there????
- AnonymousNot applicable
Bump
- AnonymousNot applicable
bump
- alurpalRegular Visitor
Has there been an update that solves this yet?
Workaround: For visuals that support the "Tooltips" section, you can add any field you want to tooltips and it will show in the "show records" table.
- AnonymousNot applicable
Is there seriously still no fix for this after 2+ years on these boards?! C'mon Microsoft! The people want this feature, now add it!
- brendaivett
Advocate II
Hi everybody,
I found in this link http://community.powerbi.com/t5/Desktop/In-line-hierarchy-levels-for-drill-down-in-power-bi-desktop/td-p/33427
this "Seems like it is picking up all the text based fields when you see click records."
It doesn't make sense, but that's how it works, the "see records" include the fields that are already part of the visualization you're working on, plus the text based fields left on your table, so, I tested changing the datatype of one of my measure fields that I wanted to show into a text, and when I right-clicked for the "see records" option, now I could see the field I was testing with in the records.
Hope this helps! at least while it's fixed.
Brenda
- jeromeFrequent Visitor
Thanks, that works, but is quite unfortunate that we need to do this work-around. I was really excited when they added the "See Records" feature. That feature is incredibly valuable for us. However, that certain fields are filtered out is a major flaw. We also need to be able to rearrange fields the way we want to.
- Vicky_Song
Impactful Individual
jerome, brendaivett, Anonymous, jcarville, ZLJ, as what I mentioned in this case, you can use Values pane in Visualization to include, exclude and re-order some columns. Then, you will get columns exactly what you want when you export data.
Does it work for you?
- jesuisbenjamin
Advocate I
I need the See Records to display specific columns to be meaningful to the stakeholders I create the reports for. Currently the PowerBI seems to select random columns and after I edit the See Records view, the columns revert to their default random selection each time I exit the See Records view. It's just useless. Can this be addressed?
- DeaniousNew Member
I'm with all the others on this one.
I use this function alot now thats its been added. And i'm sure that they will update it so that we can customise what records are shown.
But i need to set them differently for each page or set of data not just a one for all all for one drill down.
- DeaniousNew Member
I'm with all the others on this one.
I use this function alot now thats its been added. And i'm sure that they will update it so that we can customise what records are shown.
But i need to set them differently for each page or set of data not just a one for all all for one drill down.
- hughesie17New Member
I'm in the same boat. The workaround is tedious at best. I can't add/remove/reoder the columns so the details are meaningful for my users and stakeholders when text fields are the only ones showing up. Some of the fields I need to show them are tied via relationships as well so even if they can select their own fields...they won't understand the data relationships and won't know what to select. That's really beside the point, though, because if users see the option "See Records" they will expect that those records will already be meaningful - currently the limited functionality prevents this feature from being very useful, if at all, for users/stakeholders.
- mkeiperFrequent Visitor
Would like customizable "See records" also. As DJ Khaled once said "Another One"
- petersi
Helper II
This is ridiculous - whoever put this together should be fired - they left an incomplete/in properly implemented feature go into production. Christ -- didn't they even test this out?
- kscofield21Regular Visitor
Also need this addressed. Would just like to customize the columns people can view when they click "See Records"