“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.

[v-echaithra]

Hi @Vallance ,

We would like to confirm if you've successfully resolved this issue or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.

Thank you for your patience and look forward to hearing from you.
Best Regards,
Chaithra E.

[v-echaithra]

Hi @Vallance ,

We wanted to follow up to see if the issue you reported has been fully resolved. If you still have any concerns or need additional support, please don’t hesitate to let us know, we’re here to help.

We truly appreciate your patience and look forward to assisting you further if needed.

Warm regards,
Chaithra E.

[rohit1991 · Accepted solution]

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.

[DavidBoes]

I have this same problem with a dynamic list of customers.  Is there a way to turn off or overide parameter validation?  Is there a way to tell the system to ignore a parameter?  Is there a way to tell it to include all records without filtering on that parameter without removing the parameter altogether?

Thanks,