Power Platform Community Forum Thread Details

Ask: To send across a screenshot of a Power BI report page with respective filters via email to relevant SPOC.

Process: Created a Power Automate flow as follows:

Manually trigger the flow
Read table from excel file, located in a Share Pojnt folder
Create a loop where it takes the Workspace, Report, Page and Filter details from the excel file (Step 2) and take the screenshot in PNG format - for markets available in the Excel sheet (Step 2)
Convert the PNG to base64 to convert into HTML format so that it can be incorporated within the email body in the next step.
Send across emails to respective SPOCs, along with the screenshot attached in the body along with some text.

Issue: The screenshot is not being attached as a part of the email body.

This flow is up and running for 1 Power BI report, but it is not working for another report which is available in the same workspace.

The only difference between both the flows is the sheet that is being read from the excel in Step 2. The table in the excel has exactly the same headers, the difference is in the content. The flow was working for both the reports until last week, but this week the flow of Report 2 is unable to attach the screenshot within the email body and Report 1 is still working fine, with no issues.

Tried solutions but failed:

Created a copy of the working flow and made changes in it.
Created the entire flow from scratch.
Created the excel sheet from scratch.
Created a duplicate of the Power BI report page, used Page ID of the duplicated page in the excel sheet where all details are available. (Step 2 of Process).

Note:

The screenshot is being generated as I added another step to download the file, and it is coming as expected.

The filters are also valid as I manually applied the same filters on the Power BI service to confirm.

There are no credentials related issues/report access related issues - as the flow worked successfully last week.

If anybody has faced this or has any solutions that can help me get the screenshot attached to the email body, please let me know.

Thanks in advance!