Unable to show all fields from a table\view within a SSRS Report Model for user selection


  • I recently added a new view with a simple SELECT (with 3 fields) statement to our existing Report Model DSV. I then went ahead to the report model (.smdl) file proceeded with the auto-generation of the new attributes which of course ran with no issues. I was seeing the three new fields as attributes. But when I went within the existing Perspective to add the newly added fields so that the users see them, one of the field is missing. It is just a VARCHAR field. What would it cause this field to not show up within a Perspective?

    Any help is greatly appreciated.Thanks,



    • Edited by NMan47 Monday, August 25, 2014 9:13 PM
    Monday, August 25, 2014 9:03 PM

All replies

  • Hi NM,
    I am trying to involve someone more familiar with this topic for a further look at this issue. Sometime delay might be expected from the job transferring. Your patience is greatly appreciated.

    Thank you for your understanding and support.
    Katherine Xiong

    Katherine Xiong
    TechNet Community Support

    Wednesday, August 27, 2014 8:48 AM
  • Hi NM,

    Could you provide the demo report in order that we can reproduce the issue on our end? Sorry for the inconvenience. You can upload it to any public workspace on the web in order that we can download it.


    Tuesday, September 30, 2014 5:23 AM