cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

How to Send PowerBI Reports Or Screenshot of report via Email

Hi,

I have made some reports in power bi for dynamics 365 online by getting all the data from dynamic 365 online. Now i want to know if there is some way that i can make a flow that will send the screenshot or may be the complete power bi report to specified email addresses?

 

Thanks.

1 ACCEPTED SOLUTION

Accepted Solutions
v-yuazh-msft
Community Support
Community Support

Hi @WaleedBinAfzal,

 

If you want to send the screenshot or may be the complete power bi report to specified email addresses, you could consider send the screenshot or the complete power bi report as the attachment of the email.

 

You could save the screenshot or the complete power bi report in a onedrive folder firstly.

 

If you have only one screenshot or the complete power bi report in a onedrive folder, or you have mutiple files in the folder and you want to send each attachment in an email, you could refer to screenshot below to create the flow:

Capture.PNG

 

 

If you have mutiple files in the folder and you want to send all attachments in one email, 

I have made a test on my side to save three files in the folder in onedrive, and you could refer to my screenshot to create the flow to send the three files as attachment of an email as below:

Capture.PNG

Capture.PNG

 

Note: the expression of contentBytes in the Compose as below:

body('Get_file_content')?['$content']

The flow would run successfully to send the email with three attachment as below:

Capture.PNG

 

Capture.PNG

 

 

 

 

Please let me knw if your problem could be solved.

 

 

Best regards,

Alice

 

 

 

View solution in original post

6 REPLIES 6
v-yuazh-msft
Community Support
Community Support

Hi @WaleedBinAfzal,

 

If you want to send the screenshot or may be the complete power bi report to specified email addresses, you could consider send the screenshot or the complete power bi report as the attachment of the email.

 

You could save the screenshot or the complete power bi report in a onedrive folder firstly.

 

If you have only one screenshot or the complete power bi report in a onedrive folder, or you have mutiple files in the folder and you want to send each attachment in an email, you could refer to screenshot below to create the flow:

Capture.PNG

 

 

If you have mutiple files in the folder and you want to send all attachments in one email, 

I have made a test on my side to save three files in the folder in onedrive, and you could refer to my screenshot to create the flow to send the three files as attachment of an email as below:

Capture.PNG

Capture.PNG

 

Note: the expression of contentBytes in the Compose as below:

body('Get_file_content')?['$content']

The flow would run successfully to send the email with three attachment as below:

Capture.PNG

 

Capture.PNG

 

 

 

 

Please let me knw if your problem could be solved.

 

 

Best regards,

Alice

 

 

 

Hi Alice,

Thanks for that much detailed answer, it helps me alot. But from this answer i want to ask one more thing from you. How can i store the dynamic 365 report snapshot or dynamic 365 complete report on one drive? Is there any way through which i can automate that process as well? It would be great if you can help me in this regard as well.

 

Thanks.

Hi @WaleedBinAfzal,

 

You could save the files in your computer and then upload the files to your onedrive for business.

 

Best regards,

Alice

schuess3
Kudo Kingpin
Kudo Kingpin

Is there anyway to automate the capture of the screenshot of the Power BI Report?

schuess3
Kudo Kingpin
Kudo Kingpin

Can we pick the Email id dynamically and send it to the user who ever clicks the button instead of mentioning the static email id.

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (5,470)