Forum Discussion
View report option always enable
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
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.