web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Get UI Element from Po...
Power Automate
Unanswered

Get UI Element from Power BI Report for data export

(0) ShareShare
ReportReport
Posted on by

Currently I'm building a Power Automate Desktop flow to automatically export data from a Power BI Report table into an Excel file. 

 

The data in the PBI report is heavily secured and thus I only have the option to export using the "more options" button in the report, as described:

 

Exporting data from a report visual in Power BI Desktop is straightforward. When you export the data, Power BI creates a .csv file with the data.

  1. Select the visual, select More options (...) > Export data.
  2. In the Save As dialog box, select a location for the .csv file, and edit the file name, if you want.
  3. Select Save.

 

The flow now consists of steps to open the Chrome browser, and navigate to the report.

 

When I want to press the web page button for more options (as described in step 1), Power Automate can't find the right UI Element and therefor keeps on crashing when executing the flow. 

 

Does anyone know how to get the correct UI Element from the More Options ... button on Power BI Reports?

I have the same question (0)
  • lbendlin Profile Picture
    8,716 Super User 2026 Season 1 on at

    You're making this more complex than it needs to be.  Run a DAX query against that dataset. You can either hand craft the query or "borrow it"  from the visual's performance monitor output.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Valantis Profile Picture

Valantis 427

#2
Vish WR Profile Picture

Vish WR 316

#3
David_MA Profile Picture

David_MA 260 Super User 2026 Season 1

Last 30 days Overall leaderboard