Showing results for 
Search instead for 
Did you mean: 
New Member

Filtering and Sending PDF Reports from Power BI by Email

Hi all, 


I have a report in Power BI using data from an SQL database.


I'm keen to automate a weekly report to go out to different staff members and am wondering if Power Automate can do this. Ideally, Power Automate would filter the Power BI report by project (this is a variable in my database), create a PDF of the report, and then send the PDFS to the email addresses related to that project (another variable).


If this can be achieved without PDFs - sending a 'pre-filtered', published version of the report to those emails, even better - to keep the interactivity / ability to drill down, scrollable lists, etc.


I've done some searching for a solution to this, but cant find what I'm looking for. Any advice on whether this can be done, and relevant tutorials would be much appreciated!


Helpful resources

Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (2,324)