Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
blndspt
Frequent Visitor

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 4
Anonymous
Not applicable

Isn't much point in a subscription if all it's going to do is send the same data - Microsoft should at least have included a "default" date on a date slicer for a subscription to begin with.

GilbertQ
Super User
Super User

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




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Wow 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




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors