Forum Discussion
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 ...
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
Thanks, GilbertQ. I didn't know that was an option. I will give this a read. Hope it's the solution!