
Announcements
Goal: Export the data from a power BI web page to excel.
I have a desktop flow that is mostly working. The flow pulls the page properly in Chrome, sets the proper filters so the correct data is displayed. However, the export feature is accessed by hovering the mouse just above the right of the list box with data. That causes a hidden control to be displayed saying, "More Options," and then "Export Data" is shown and can be selected.
However, I have no idea how the desktop flow can access that option and get the data exported.
The attached file has some screenshots of the page.
There are a couple of options you may want to consider as alternatives
- run this from Power BI Desktop
- run this from Power BI Service
- run this from Power Automate Cloud where you can specify DAX queries (and supply the query that was used to render that visual)