Report Parameters in SSRS Data Feeds for PowerPivot - by David Beavonn

Status : 


Sign in
to vote
ID 800595 Comments
Status Active Workarounds
Type Suggestion Repros 0
Opened 9/13/2013 6:47:38 AM
Access Restriction Public


Need a way to hide SSRS report parameters in the data feed definition (atomsvc).

Currently report parameters are shown prominently at the front of the data feed columns.  However, these are redundant since most well-written RDL will include parameters in the report body (after making them esthetically pleasing or user friendly).

There should be a way to hide report parameters from showing up at the front of the data feed, since users may mistake them for report data and/or they may be duplicate and/or they may be unfriendly.  Aside from just hiding them, another possibility would be to move the SSRS report parameters into another collection available to be mapped separately into PowerPivot (similar to what happens when two tables exist in a report)

More discussion may be found here:
Some of our RDL reports are triggered from SSRS API's and users never see the report submissions exposed in "Report Manager" or "SharePoint".  These types of reports can have very unfriendly parameters (business keys, surrogate keys, MDX members, snippets of XML, etc).   These types of reports would never need their report parameters published into a data feed.   If anything, the developer would deliberately transform and show the necessary parameters in the report body itself.
Sign in to post a comment.
Posted by Microsoft on 6/4/2014 at 3:26 PM
Thank you for submitting this feedback. After carefully evaluating all of the suggestion items in our pipeline, we are closing items that we will not implement in the near future due to current higher priority items. We will re-evaluate the closed suggestions again in the future based on the product roadmap.
Thanks again for providing the product suggestion and continued support for our product.
Matt Jones
SSRS Tiger Dev Team
Posted by Microsoft on 5/16/2014 at 1:47 PM

Thank you for submitting this feedback. We are investigating the issue and will update you when we have more information.

Matt Jones
SSRS Tiger Dev Team