Forum Discussion

Abdelmajid's avatar
Abdelmajid
Icon for Helper I rankHelper I
5 years ago
Solved

Power BI report subscription keeps stop working after a successful few deliveries

Hello,   Few of our Power BI subscription run successfully for few after configuration. But, stop working after that with te below error under result: "The subscription contains parameter values t...
Power BI report subscription keeps stop working after a successful few deliveries
  • RobThrive's avatar
    RobThrive
    5 years ago

    I'm assuming this is actually for an SSRS (paginated) report in report server?

    Here is what happened when I had this same issue

     

    I developed a report in the test environment. I had a parameter which took it's available values from a query. That query looked up all the values in "CreatedByUser" column from table ABC in SQL. Great so now I have 10 users in the report drop down.

    When I published to the live environment, i setup a subscription and changed the parameter to "User10". problem was, "User10" hadn't created any data in our table in live yet! so the subscription failed with the same reason you have listed above.

     

    I changed my code to the below, to now populate the username dropdown:

     

    SELECT distinct username FROM table_ABC
union
'User10".

     

    No longer matters if there is no data in there for this user when I deployed and setup the subscription. Just means they'll get no data in the report.

RobThrive's avatar
RobThrive
Icon for Resolver I rankResolver I
5 years ago

I'm assuming this is actually for an SSRS (paginated) report in report server?

Here is what happened when I had this same issue

 

I developed a report in the test environment. I had a parameter which took it's available values from a query. That query looked up all the values in "CreatedByUser" column from table ABC in SQL. Great so now I have 10 users in the report drop down.

When I published to the live environment, i setup a subscription and changed the parameter to "User10". problem was, "User10" hadn't created any data in our table in live yet! so the subscription failed with the same reason you have listed above.

 

I changed my code to the below, to now populate the username dropdown:

 

SELECT distinct username FROM table_ABC
union
'User10".

 

No longer matters if there is no data in there for this user when I deployed and setup the subscription. Just means they'll get no data in the report.