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

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
Syndicate_Admin
Administrator
Administrator

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

5 REPLIES 5
schuess3
New Member

schuess3
New Member

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

Syndicate_Admin
Administrator
Administrator

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

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

Power BI Dev Camp Session 22 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!