Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
krichmond
Helper IV
Helper IV

Is it possible to leverage Power Automate to auto run reports with a dynamic filter applied?

We have a report in Power BI that has a filter for Client ID. This ID is unique to each of our clients. Is it possible to leverage Power Automate to automically pull a single report for a single Client ID and export it into PowerPoint format?

5 REPLIES 5
lbendlin
Super User
Super User

yes. Try it out.

@lbendlin - I am only seeing the ability to do this with paginated reports. The one I specifically stumbled across is called "Export a Power BI paginated report for each row in an Excel Online table". However, when I go to set up a test, I can see all of our workspaces... I just don't see any reports listed under them. Is there a way to basically do this without the dependency of having to have paginated reports?

 

Screenshot 2023-02-07 142633.png

Works for me  (apart from the well known performance issues)

lbendlin_0-1675803357876.png

 

@lbendlin - Are you using paginated reports?

No, regular reports.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.