Forum Discussion

dwa777's avatar
dwa777
Frequent Visitor
2 years ago

Dynamic Subscriptions and a Paginated Report with a multi-value parameter

I've got a Paginated Report that has a multi-value parameter list. Multiple customer numbers can be selected with this parameter for generating the report output.   For a Dynamic Subscription, how ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi dwa777 ,

I think you can do this in Power BI by setting up dynamic subscriptions for paged reports.

First you can select the "Dynamic per recipient (preview)" option in the subscription pane.

Select the Power BI dataset that contains the recipient data, including the email address and the corresponding parameters Map the columns in the dataset to the corresponding parameters in the subscription settings. This will ensure that each recipient receives a copy of the report with the respective parameters applied.

If you want to send a single report to [email protected] with multiple customer numbers, there will be a row in the semantic model where [email protected] is the email and 12345, 23456, 34567 are the customer numbers. When setting up a dynamic subscription, you need to map the Customer Number column to a multi-valued parameter in the report. This way, you can send a personalized copy of the report to each recipient and apply the specified parameters without having to generate multiple reports for each parameter value.

 

 

 

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • dwa777's avatar
    dwa777
    Frequent Visitor
    2 years ago

    Hello,

     

    Thank you very much for the reply and suggestion. Unfortunately passing a comma separated value from the semantic model column to the multi-list parameter of the report doesn't work. You would think logically it would work but it dosen't.

     

    It sends the following error in the subscription output email:

    "DataDrivenSubscriptionEmailNotDeliveredError

    1 out of 1 subscriptions failed.

    Render Failed - Recipients: [email protected], ExtensionType: EXCELOPENXML, Parameters: [CustomerNumber]:815, 577, 794, ErrorDetails: Unable to render paginated report, ErrorCode: rsParametersNotSpecified"

     

    Note that if I only pass a single value, it works. I also tried to remove the spaces from the comma separated string, keeping only the commas, and that did not work either. I think it's trying to lookup the entire value "815, 577, 794" rather than separating the values.

     

    After researching, it looks like this same issue was known with the old SSRS Data-Drive Subscriptions also.


    Thanks you for the help however. If you have anything else to try let me know please.