topic Re: Where are the "see records" columns setup? in Developer

Where are the "see records" columns setup?

brendaivett — Fri, 06 May 2016 18:59:23 GMT

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

Re: Where are the "see records" columns setup?

ZLJ — Tue, 10 May 2016 09:20:53 GMT

I have the same issue. I want to add columns and change the order of the columns, all of which i can do when i am looking at the records, but they are gone when i drill back in.

Re: Where are the "see records" columns setup?

jcarville — Fri, 13 May 2016 10:34:11 GMT

I am having the exact same issue.

I have a Column (Column A) that is made up by subtracting Column B from Column C, however only Column A is shown, but I would like all 3 Columns to be shown.

Has anybody found a way around this?

Re: Where are the "see records" columns setup?

Anonymous — Fri, 13 May 2016 12:49:05 GMT

Hi,

This has also been a thorn in the side of my dashboards for some time. The columns where I have calulcated a figure appear, but not the columns used to generate said figure.

If anyone could help it would be very much appreciated.

Re: Where are the "see records" columns setup?

brendaivett — Mon, 16 May 2016 17:00:38 GMT

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

Re: Where are the "see records" columns setup?

jerome — Tue, 17 May 2016 13:52:45 GMT

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.

Re: Where are the "see records" columns setup?

Vicky_Song — Sun, 22 May 2016 07:40:22 GMT

@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?

Re: Where are the "see records" columns setup?

ZLJ — Mon, 23 May 2016 08:01:07 GMT

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.

Re: Where are the "see records" columns setup?

Vicky_Song — Tue, 24 May 2016 02:26:43 GMT

@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.

Re: Where are the "see records" columns setup?

jerome — Tue, 24 May 2016 12:38:37 GMT

Hi @Vicky_Song,

It works for me as an administrator, but my users are unable to the Values pane. They can only see the filters pane and so this workaround does not help my other users. Thank you for the suggestion though.

Re: Where are the "see records" columns setup?

LarryM — Tue, 07 Jun 2016 20:22:19 GMT

The "see records" function works for me for reports, but after I pin the report to a Dashboard, it doesn't work on the Dashboard, even though the "see records" option is displayed on a right-click of a column of data. Has anyone else seen this behavior?

Re: Where are the "see records" columns setup?

Najeeb — Wed, 29 Jun 2016 13:53:17 GMT

Hi everybody,

I have the same issue. I want to add columns and change the order of the columns, all of which I can do when I am looking at the records, but they are gone when i drill back in.

Re: Where are the "see records" columns setup?

jesuisbenjamin — Sat, 09 Jul 2016 11:08:19 GMT

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.

Re: Where are the "see records" columns setup?

jesuisbenjamin — Sat, 09 Jul 2016 11:13:20 GMT

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?

Re: Where are the "see records" columns setup?

Deanious — Tue, 12 Jul 2016 10:04:58 GMT

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.

Re: Where are the "see records" columns setup?

Deanious — Tue, 12 Jul 2016 10:06:49 GMT

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.

Re: Where are the "see records" columns setup?

hughesie17 — Tue, 12 Jul 2016 14:50:00 GMT

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.

Re: Where are the "see records" columns setup?

alurpal — Tue, 13 Sep 2016 19:53:10 GMT

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.

Re: Where are the "see records" columns setup?

Willborn — Fri, 14 Oct 2016 05:13:55 GMT

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

Re: Where are the "see records" columns setup?

pls — Tue, 18 Oct 2016 15:24:40 GMT

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