Forum Discussion

jr7138's avatar
jr7138
Regular Visitor
3 years ago
Solved

PowerBI Report Server - Dataset Delivery options

I have a report with SQL query and a delivery option of using a dataset. The dataset has a list of 17 groups to send to. Everything works as it should, but my question is:   How many loops does the...
Report Server
  • d_gosbell's avatar
    d_gosbell
    3 years ago

    Assuming this is a data driven subscription. If the dataset driving the subscription has 17 rows the report will be run 17 times. If the report is identical with the same parameter values for each of the 17 groups then you would be better to have just a single subscription sending the report to the multiple addresses. I think you can just separate the addresses with a semi-colon eg. [email protected];[email protected]

d_gosbell's avatar
d_gosbell
Icon for Super User rankSuper User
3 years ago

Assuming this is a data driven subscription. If the dataset driving the subscription has 17 rows the report will be run 17 times. If the report is identical with the same parameter values for each of the 17 groups then you would be better to have just a single subscription sending the report to the multiple addresses. I think you can just separate the addresses with a semi-colon eg. [email protected];[email protected]