My experience in Power BI is moderate at best, and the only success I've had in Power Automate is an automated email with a Power BI page attached. My approaches have probably been suboptimal, so I could use some help.
I have a Power BI report with a single page and an Excel spreadsheet with 3 tables. My goal is to send an email through PA with a PDF attachment that includes the Power BI report and Excel tables. This feels like it shouldn't be a daunting task, but I'm struggling to figure out how to append these data sources together as an email attachment.
Currently, I'm pulling the Excel tables separately with "List rows present in a table". All the tables are formatted as tables, not ranged. I've confirmed I'm pulling the correct ones in by the table names in the worksheet. When I try to "Create File" from the contents, "File Contents" is not an option. The dynamic content suggestions are metadata or the table column headers.
I'm pulling the Power BI data with "Export To File for Power BI Reports". I'm able to create a pdf from this without much issue.
So far, I've tried:
- Appending them together by creating an array variable and appending the outputs
- Creating a temporary Word document to thereby generate a PDF
- Creating an HTML table for the Excel tables
Google and ChatGPT haven't been very helpful in getting me closer to the endgoal. If anyone has a solid grasp on how to do this, I'd very much appreciate some insight.
