Reply
krichmond
Helper IV
Helper IV
Partially syndicated - Outbound

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

Syndicated - Outbound

yes. Try it out.

Syndicated - Outbound

@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

Syndicated - Outbound

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

lbendlin_0-1675803357876.png

 

Syndicated - Outbound

@lbendlin - Are you using paginated reports?

Syndicated - Outbound

No, regular reports.

avatar user

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.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)