As of yesterday Dec 7th, users are unable to execute pagination reports in the Power BI service and receive an error saying parameter values have not been specified for optional (allow blank) paramet...
Anonymous
We've had different issues because of recent Gateway updates which forced us to rollback to prev version of gateway, which seem to have resolved our older, non related issues.
This paginated reports optional parameters issue started just today.
One workaround by another colleague of mine was to supply a default value (% or equivalent) for each of optional parameter. This works if your where clause is using LIKE (i.e match pattern) comparator. haven't tested with differnet databases or =, >=,etc comparators.