cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

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
Highlighted
Community Support
Community Support

Re: How to Send PowerBI Reports Or Screenshot of report via Email

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

3 REPLIES 3
Highlighted
Community Support
Community Support

Re: How to Send PowerBI Reports Or Screenshot of report via Email

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

Highlighted
Helper I
Helper I

Re: How to Send PowerBI Reports Or Screenshot of report via Email

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.

Highlighted
Community Support
Community Support

Re: How to Send PowerBI Reports Or Screenshot of report via Email

Hi @WaleedBinAfzal,

 

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

 

Best regards,

Alice

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

Join the new Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Users online (6,502)