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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
RussellBode
Helper I
Helper I

View report option always enable

Hello 

How i can setup this view report option always enable?

currently its not once i check on it i need to change parameter or refresh report then select all parameter

RussellBode_0-1761790183178.png

 

6 REPLIES 6
v-sshirivolu
Community Support
Community Support

Hi @RussellBode ,

Thank you for the update and for clarifying the issue with setting the default to All values. Based on your description, it’s clear that configuring a dynamic default value such as selecting the latest or a specific Pay period will be more effective than using a static All, especially if your Pay period parameter allows multiple selections or relies on another parameter. The View Report button in paginated reports typically remains disabled when any parameter lacks a valid default or when cascading parameters aren’t resolved properly.

Here’s how to address this: In Power BI Report Builder, navigate to Report - Report Parameters. For each parameter, open Parameter Properties - Default Values and assign a default. Use Specify values for a fixed default or Get values from a query for a dynamic option. For example, to automatically select the latest pay period, use a query like:
SELECT TOP 1 PayPeriodID FROM PayPeriods ORDER BY StartDate DESC
Ensure every parameter, including hidden or optional ones, has a valid default. If your Pay period parameter supports multiple values, use this expression to preselect all: =Parameters!PayPeriod.AvailableValues

For cascading parameters, confirm that parent parameters have valid defaults so the child parameter (Pay period) can resolve correctly. Then, go to Report Properties - General and enable Auto-run when all parameters have default values, so the report loads automatically. After setting up defaults, preview the report to verify that the View Report button is enabled. Once confirmed, publish to Power BI Service and test again. If issues persist, check for invalid queries, missing defaults, or an outdated Report Builder version. This approach will ensure your report functions as intended.

Refer to these Microsoft’s official documentation:

Report parameters in Power BI Report Builder 
Set default values for report parameters 
View parameters for paginated reports in Power BI Service 

Hope these steps should keep the View Report button always enabled and make your report load automatically with the correct Pay period selected by default.
Thank you.

Hello @v-sshirivolu 

I tried this it works in Report builder but not when i publish.

after publish it doesn't work.

as well as report General property doesnt have same option here for auto run

 

RussellBode_0-1761860524297.png

 

Shahid12523
Community Champion
Community Champion

Set default values for all parameters
Avoid cascading parameters without defaults
Enable auto-refresh or load-on-open behavio

 

Shahed Shaikh

Hello I want have default for the selected Pay period

 

Rufyda
Kudo Kingpin
Kudo Kingpin

Set default values for all parameters

Open each report parameter.

Assign a Default Value (e.g. “All” or “Today”).

Save the report.
→ The View Report button will stay enabled automatically.

(Optional) Enable “Auto-run”

If your tool supports it, turn on

“Auto-run when all parameters have default values”
→ The report runs automatically on load.

If this response was helpful, please accept it as a solution and give kudos to support other community member.

hey I tried this to add the Default to all values

but still didnt work

RussellBode_1-1761800366718.png

 

 

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.