I am trying to create a Power Automate flow which runs a powerbi report and send output in PDF format for each user only their information.
i have my power bi report like this
i have 100 sales persons and their email id's. I want to run my report once and send output to 100 users only the information related to them.
To achieve this I am doing following steps.
1)In step one creating recurrence
2)In step two I am running Power BI report using"Export to file for Power BI report"
3)In step three I am using OneDrive file where I have email ID's of all employees.
4)In step four I am sending an email using Outlook.
Flow is executing and sending email without any errors but it's sending complete report output to all users.
Can you please suggest any steps which runs the report and then send email with only report output related to them either using OneDrive excel email id's or using existing Power BI Report columns (Email ID)?
Thanks in Advance.