Forum Discussion
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
Hello
so if preview feature is disable then we can click on view report again and again and just fetch the details again without refreshing link
8 Replies
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
Set default values for all parameters
Avoid cascading parameters without defaults
Enable auto-refresh or load-on-open behavioHello I want have default for the selected Pay period
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.AvailableValuesFor 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 ServiceHope 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
Hi RussellBode ,
The reason your defaults work in Report Builder preview but fail after publishing to Power BI Service is that the local preview connects directly to your data, while the service depends on scheduled refreshes, gateway access, or dataset queries that might return no rows, causing parameters to lose their defaults and disabling the View Report button. To fix this, open your report in Report Builder, right-click each parameter (including PayPeriod and cascading ones), and under Default Values, select Get values from a query using the same dataset and value field as the available values (like PayPeriodID). This dynamically loads all values or the latest one without hardcoding. For cascading parameters, ensure parent defaults load first, e.g., use a query like SELECT TOP 1 PayPeriodID FROM PayPeriods ORDER BY EndDate DESC. If multi-value defaults still blank out, add custom code under Report Properties > Code to return all IDs as a comma-separated string, then set the default expression to =Split(Code.GetAllValues(Parameters!PayPeriod.Dataset), ","). Finally, enable Run report automatically when parameter values change in Report Properties > Settings to skip manual clicking. After saving, republish the report, verify dataset credentials and gateway mapping in the service, then test in an incognito browser. This setup ensures your report loads automatically with valid defaults and keeps the View Report option always active.
Hello
so if preview feature is disable then we can click on view report again and again and just fetch the details again without refreshing link
