SQL Stored Procedure Equivalent in PBI?

[Tadder]

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

[GilbertQ]

Hi @Tadder 

Could you not write a query to bring in all the data for all the sales people into a single semantic model? Once you. have it in the semantic model, you could then use the new dynamic subscriptions to send out an email to each user based on the orders. Create a dynamic subscription for a Power BI report - Power BI | Microsoft Learn

[Tadder]

Thanks, GilbertQ.  I didn't know that was an option.  I will give this a read.  Hope it's the solution!