Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
brendaivett
Advocate II
Advocate II

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 68
kb
Frequent Visitor

Is there any update in this case? 

CA
Frequent Visitor

I'll add a bump here too!

seaton
New Member

The closest thing that I found, as I too was having this problem, was to go to the data view.  Choose the table with the columns you do not want to display, right click Hide in Report View.

 

 

 

While this doesn't do anything for the sorting, it does retain only the columns you want to see as you flip back and forth from the charts to the see records option.

finnpowerbi
Regular Visitor

Yes, me too....

I have really enjoyed using Power BI and have created some reports and dashboard, but it will be very helpfull, if we could save the changes we have made in 'see records'.

 

Finn, Denmark

pls
Regular Visitor

Hi,

 

I have this issue too.  

 

Plus in my example it is selecting a calculated column and applying Date Hierarchy to it, but because it's not a date (it's just a text description of a financial year - its data type is text), this means it can't show the visual.  When I change the setting for that column in Values in the Visualizations pane (from Date Hierarchy to just showing me the contents of the calculated column), the records show (albeit in an order I'd like to be able to edit), but next time I go back in, Date Hierarchy is applied by default again, and it can't show the records again until I change it back.

 

Frustrating, and rendering Power BI less useful than the once-a-month Excel reports users currently get from me.

 

Paul

 

Zwakele
Frequent Visitor

Any luck on this? 

Anonymous
Not applicable

Lack of control over the "See records" vizualisation is turning out to be a major design headache. So I agree that this needs some work!

alurpal
Regular 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.

Hi there

I'm with all the others on this one. 

 

FYI: Mod Lydia Zhang wrote back yesterday on my post that "This issue of that how “See Records” works has been reported internally, once we get any updates , we will post back." - So MS heared us!

 

Regards, Patrick

 

 

hughesie17
New 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.

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?

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.

 

 

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.

 

 

Hi there,

 

I have the same issue. I need to display certain columns in see records for the records to be meaningful to those I produce the reports for and right now everytime I change the columns to display in See Records, it does not save my selection and reverts to the default columns after exiting the See Records.

 

Is there no fix for this? It's just useless this way.

brendaivett
Advocate II
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/...

 

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

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. 

What if you want to configure what is displayed by default when the user selects see records. This optiopn is only good for the user to perfrom manually. It makes no sense why non test fields that are not included in the explicilt visualization do not show up automaticvally in See Recxords. And when you do add them they do no0t stay as part of the configuration for the visualization.

Vicky_Song
Impactful Individual
Impactful Individual

@jerome@brendaivett, @Anonymous, @jcarville@ZLJ, as what I mentioned in this caseyou 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.

 

P2.png

Does it work for you?

hello Vicky,

 

i cant find the Values pane in my power bi free version, can you please advise me how to get that pane?

 

thanks and regards,

glen

 

Hi @Vicky_Song  

Do you mean in the original visualization or in the See Records visualization?

When i do this to the original, it then distorts the visual as it is pulling in values i do not want included at all.  When i add them in See Records, they dont keep once you go back to the report and drill in again later / via another route.

Vicky_Song
Impactful Individual
Impactful Individual

@ZLJ, I mean in the 'See Records' visualization. You are right that these filters don't keep once go back to the report, however, you can take it as a workaround to choose columns you want when you're going to export data. I'm still waiting for the updates from our senior engineers on how 'See Records' works. Will reply back once I get any updates.  

Helpful resources

Announcements
March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.