Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

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

(0) ShareShare
ReportReport
Posted on by 10

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:

 

Unknown__1-1669223921496.png

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:

 

Unknown__0-1669223277956.png

 

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

Like this:

Unknown__3-1669225154893.png

 

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

Can you help me?

 

Thanks

  • lbendlin Profile Picture
    8,041 Super User 2025 Season 1 on at
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1