
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.
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?
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.