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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
cgarst
Regular Visitor

Updating a Subscriptions parameter value but not to default

Hello!

 

I have a paginated report subscription that I would like to run every day and one parameter is date. I would like the date value to be the todays date, but the default value is set to yesterdays date. I have subscriptions set up for different people that need to use both settings, so I can not just change the default value. Is there a way to support this?

 

Best,

Callan Garst

1 REPLY 1
Jon-Heide
Microsoft Employee
Microsoft Employee

Not sure I follow the scenario completely. But, currently, a subscription allows for a single set of parameter values. If you are creating two separate subscriptions, you could add a second parmaeter called "UseToday". Then, based on that value of that parameter, create an expresson that uses today's date. Examples of date expressions are here:  https://stackoverflow.com/questions/15940940/how-do-i-display-todays-date-on-ssrs-report

 

 

 

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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

Top Solution Authors
Top Kudoed Authors