How to Send PowerBI Reports Or Screenshot of report via Email

[Syndicate_Admin]

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.

[schuess3]

I think this is what you and I are looking for: https://powerbi.microsoft.com/en-us/blog/export-report-to-pdf-pptx-and-png-files-using-power-bi-rest... 

[schuess3]

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

[Syndicate_Admin · Accepted solution]

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:

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:

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:

Please let me knw if your problem could be solved.

Best regards,

Alice

[xyzabhi]

Hi, I want to send screenshot of reports automatically via email

[Anonymous]

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.

[Syndicate_Admin]

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.

[Syndicate_Admin]

Hi @WaleedBinAfzal,

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

Best regards,

Alice