Forum Discussion
Subscriptions with "Parameters"
Hey guys,
I'm a little embarrassed to even ask this question. I've built a ton of reports in the past in SSRS, and know subscriptions therein very well. I have a few dozen reports and dashboards on which I'm creating subscriptions to deliver dynamic data. After googling high and low I'm not finding this concept to be very obvious!?? Here is a very simple example - you make a date range slicer (or a relative date). I'd like to create a subscription for a report that filters by a dynamic range depending on the subscription (as in "the last 3 days" or "this week").
Am I simply missing something in my lack of success on finding out how to do that? I would have thought that subscriptions would behave similarly to SSRS reports with parameters.
Sorry if this is obvious. Thanks everyone.
Scott
4 Replies
- Hi there
Currently subscriptions cannot include parameters.
What you create in the dashboard or report is what is sent out in the subscription.
You can vote for an idea on https://ideas.powerbi.comWow seriously? That seems like a pretty core feature of a subscription to me! I'm shocked. I have no way of customizing a subscription with a simple parameter - I have to duplicate reports to send them 2 different ways? Yowser. Is there some kind of work around folks have used? My god all I wanted to do was send a daily and weekly report with the same report using "last 1 day" versus "last 7 days" in a subscription.
- You can use Paginated reports which is available in Power BI Premium where you can pass parameters.
Otherwise you can vote for an idea on https://ideas.powerbi.com
