Answered

Automate a screenshot from a PowerBI report

(0) Share

Report

Posted on by Raphael33

Hi,

I have to build a flow that allows me to automatically take a screenshot from a PowerBI page, to then include that PNG into the body of an automated email. Here is my flow, but when I receive the email, no image appears. Could you please help me.

I then entered the following code in the "Initialize Variable" action :

Thanks for help !

Raphaël

Categories:

General topics

I have the same question (0)

All responses (13)

Answers (1)

v-yueyun-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi , @Raphael33
According to your description, you want to embed the png in your email body.
I test it in my side , you need to ensure you return the file content type is "image/png" in your flow run historty:
For example , if your Power BI report have more then one pages, it will return zip file content type when you do not give the "Pages pageName" parameter. This will return all the pages as PDF files in a zip file.

So you can first give a page name in this field to test:
Then we can use this expression in Send Email action:
<img src="data&colon;image/png;base64,
outputs('Export_To_File_for_Power_BI_Reports')?['body']?['$content']
" alt="Power BI Report" />

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No
Raphael33 32 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-yueyun-msft ,

I tried what you did, and it still returns an empty space in my email body :
Then I ented your script in the email :
And finally here is what I receive :

Was this reply helpful? Yes No
v-yueyun-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi , @Raphael33
Sorry, it seems i copy the wrong code and i do not know why i put the ":",it will convert it to "&colon;"😅 , you can try to use :
You need to use the ":" instead of the "&colon;". Like this in thescreenshot:

outputs('Export_To_File_for_Power_BI_Reports')?['body']?['$content']

" alt="Power BI Report" />

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No
Raphael33 32 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the correct script. I just wrote it and it still doesn't works, don't really understand...

Was this reply helpful? Yes No
v-yueyun-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi , @Raphael33
Thanks for your quick response! Can you try to click this and put this into here :
First , you go to the old designer in Power Automate right above corner.
It works good in my side ..

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No
Raphael33 32 on at

Like (0)

Report
Copy link

Link copied!

I wrote that script in the code view :
And it returns an empty space again :

Was this reply helpful? Yes No
v-yueyun-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi , @Raphael33
Can you show me your Export to file action return in run historty:
If this , this is my send email action:

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No
Raphael33 32 on at

Like (0)

Report
Copy link

Link copied!

I do not have the same outputs as you do :
When I download :

Was this reply helpful? Yes No
v-yueyun-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi , @Raphael33
Your output seems has no problem, the content type is image/png:
So can you check this:
In your screenshot , it seems that you add a space here?

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No
Raphael33 32 on at

Like (0)

Report
Copy link

Link copied!

I just removed the space, and still the same problem, It says that it is not possible to get an overview:

Was this reply helpful? Yes No