cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pbix Member
Member

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

 

Is there an update for this?

 

If i have a simple fact table with integer fact keys joining the fact table to an integer key in a dimension - the associated dimension description does not appear when I click 'see records' unless I add the dimension description field to the 'tooltips' section. 

 

Any update/other workarounds?

rdcooper Frequent Visitor
Frequent Visitor

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

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!

messerjc Member
Member

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

This is really affecting us right now as we're starting to use Power BI Report Server's PBI reports. We have a well-curated dimensional data model, and we're trying for now to only use Direct Query data sources so the behavior is the same as SSRS/paginated reports. I'm finding it annoying that DirectQuery does not support even basic transformations (or even just a change in view) so that when using "See Records" my datetime column always shows 12:00:00 AM with the date. Our main ID is a numeric field, and no matter what I've tried, instead of showing me the numeric ID as is it always displays the value comma seperated with .00 at the end. That all lead me to this post, and I thought I would just try to modify the way "See Records" behaves...only to find that you can't? This definitely needs some love guys.

 

Scratch most of that, of course weeks later as I post this I find the right report-wide Data type and Format modifiers in the toolbar! THAT SAID - I most definitely still would like more control over the way "See Records" is displayed.

GBruce87 Occasional Visitor
Occasional Visitor

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

Here is a potential workaround for people experiencing issues with date columns not showing up in See Records. I was able to use this method to add several date columns to the end of the See Records visualization that the users of one of my dashboards required.

 

 

Create a custom column using the following formula:

 

$ColumnName = FORMAT($Datasource[$DateColumn],"mm/dd/yy")

 

$ColumnName = Desired column header in See Records view

$Datasource = Your data source name

$DateColumn = The existing column name that contains the date in your data source

 

mm/dd/yy can be modified to the format your report requires.

 

Hopefully this helps someone. 

bryanc78 Regular Visitor
Regular Visitor

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

back to the top!!  Fix this please!!

jasonmaskell Frequent Visitor
Frequent Visitor

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

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.