Export data from Power BI and send via email to different recipients

Like (0) Share

Report

Posted on 23 Nov 2022 17:42:58 by Unknown_

Hello,

I want to create a flow that does the following steps:

1. Exports data from Power BI every month (My Power BI table has 4 columns: Sales No., Value, Date, E-mail)

2. Sends an email with the data exported to different people based on filters

The exported data should look something like this:

In this example, I would want to send an email to the two different emails represented in the column Email with only the data rows referring to its email.

Which means that, for example, when sending the email to name1.sm@gmail.com only the first 4 rows of the data should be sent on the attachment.

This behaviour should be replicated for each one of the different emails in the column Email.

I have accomplished the first step with the following flow:

However the file generated is in CSV with the values in only one column and delimited by commas.

Like this:

So, from this I am not sure how I should proceed.

Can you help me?

Thanks

I have the same question (0)

All responses (1)

Answers (0)

lbendlin 8,166 Super User 2025 Season 2 on 25 Nov 2022 at 22:21:01

Like (0)

Report

Re: Export data from Power BI and send via email to different recipients

Run separate queries, one for each of the recipients. Put the result into a CSV variable (as you already do), or create HTML directly. Then include that data in your email in the desired format or as an attachment.

Was this reply helpful? Yes No