“Some parameters do not have valid values” Error for power BI Paginated Report

[Vallance]

I have a Paginated Report with a subscription which has parameters with list of customers, products where I can select certain customers and products and see the sales for it.

I’ve selected a set of customers and products from their respective parameter drop down and got a table with the selected customers, product and their total sales, I’ve created a paginated report subscription for the same and it works fine.

Then a customer that I had selected to display in my report subscription was marked as inactive in the source database and ceise to exist in the sematic model. When I ran my subscription or when the subscription ran automatically I got an error where it said “Some parameters do not have valid values”.

One simple fix to this is to edit my Subscription and unselect the Customer that was removed from my semantic model. If I do this the subscription works fine shows the remaining checked customers in the attachment.

But is there a way for power bi to be less strict,  where if customers no longer exists in the semantic model, then my Subscription shouldnt stop/break and automatically send the data of the existing customers that are checked and present in my semantic model.

[rohit1991]

Hi @Vallance ,

Right now, if a parameter value you’ve selected in your subscription (like a customer) no longer exists in the data source, the subscription fails with the “Some parameters do not have valid values” error even if the other values are still valid.

Subscriptions always “remember” the exact parameter values you picked when you set them up. If any of those disappear from your semantic model (for example, if a customer is removed or inactivated), Power BI can’t run the subscription until you update it.

Unfortunately, there isn’t a built-in way to make subscriptions ignore missing values or just use the valid ones. You have to manually update your subscription and remove any invalid values if they get deleted from your data.