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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
User_000
Regular Visitor

Single Page Report Export via Power Automate

Hi,

 

I am trying to use power automate to export a single page of my Power BI report. Usually this is done via copying the page name on the url but the page I am trying to export doesn't seem to have a page name, just a bookmark name. Is there anyway I can get this Id or any other work arounds to this?

User_000_0-1695948773522.png

 

Thank you 

1 ACCEPTED SOLUTION
pmreis
Resolver IV
Resolver IV

Hi @User_000 

Here are 3 possible options:

1. Create a Separate Report:

If the page is not directly accessible via URL, consider creating a separate report with just the page you are interested in. This way, you can directly reference this new report in Power Automate.

2. Use RPA:

If you are able to use an Automation tool like Power Automate Desktop, you can use it to simulate the manual export, but automate the process.


3. Set Permissions for the export account:

Use an account for the export which specifically only has permissions to view the data you want to retrieve from the export. For instance, you can configure an APP audience which just has permissions to see one report page, hence the exports will also only revert the same data.


Pedro Reis - Data Platform MVP / MCT
Making Power BI and Fabric Simple

If my response resolved your issue, please mark it as a solution to help others find it. If you found it helpful, please consider giving it a kudos. Your feedback is highly appreciated!

Find me at LinkedIn

View solution in original post

1 REPLY 1
pmreis
Resolver IV
Resolver IV

Hi @User_000 

Here are 3 possible options:

1. Create a Separate Report:

If the page is not directly accessible via URL, consider creating a separate report with just the page you are interested in. This way, you can directly reference this new report in Power Automate.

2. Use RPA:

If you are able to use an Automation tool like Power Automate Desktop, you can use it to simulate the manual export, but automate the process.


3. Set Permissions for the export account:

Use an account for the export which specifically only has permissions to view the data you want to retrieve from the export. For instance, you can configure an APP audience which just has permissions to see one report page, hence the exports will also only revert the same data.


Pedro Reis - Data Platform MVP / MCT
Making Power BI and Fabric Simple

If my response resolved your issue, please mark it as a solution to help others find it. If you found it helpful, please consider giving it a kudos. Your feedback is highly appreciated!

Find me at LinkedIn

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Power BI Header Change

Power BI Header Update

Read about the exciting updates for the Power BI forum.

Top Solution Authors
Top Kudoed Authors