SQL Stored Procedure Equivalent in PBI?

Hello - I'm hoping someone out there can offer some advise.

We have several stored procedures in SQL Server that run every day/week and grabs two queries:

1. a list of SALESPEOPLE

2. a list of ORDERS

The procedure then loops through the salespeople one-at-a-time and filters the orders for each person, then sends an email with the records (line items) from the orders to the individual salesperson.  There might be 100 salespeople, so this was a VERY efficient way of getting this accomplished.  the basic steps of the SP:

a. salesperson #1

b. filter orders showing only line items where the salesperson is #1

c. send email with those line items (could be hundreds of lines or more) to salesperson

d. increment salesperson# and repeat

Is there anything like this possible using PBI Premium?

Thanks,

Tad