Report subscriptions on Power BI

Hi DinaSims1998 

This appears to be a new setting for paginated reports. What I would suggest doing is, instead of having the value coded to a month's name, like April 2025 I would recommend defaulting the value to something like current month or previous month. So that value does not change. But as time changes, the value will change to reflect the data. This should help overcome your current challenge.

Hi DinaSims1998 , Thank you for reaching out to the Microsoft Community Forum.

The issue you're facing is a known limitation in the Power BI Service. It causes parameter values to remain static, even if you intend for them to refresh each time the report runs. Define dynamic default values directly in the report using Power BI Report Builder. For example, set the parameter default to an expression like =DateSerial(Year(Today()), Month(Today()), 1) for the first day of the current month or =DateAdd("m", -1, DateSerial(Year(Today()), Month(Today()), 1)) for the previous month. Then, when creating the subscription in Power BI Service, choose “Default” for the parameter. This ensures the subscription always uses the fresh, calculated value at runtime.

If the default-setting workaround doesn't work in your environment or you need more control, Power Automate is a solid alternative. With it, you can schedule and trigger report exports using the "Export to File for Paginated Reports" action, passing dynamic parameters programmatically.

If this helped solve the issue, please consider marking it “Accept as Solution” and giving a ‘Kudos’ so others with similar queries may find it more easily. If not, please share the details, always happy to help.
Thank you.