Extract Data - Alternatives to Visual Header Option

[Anonymous]

I have a table visual which users need to export data but the More Option button sometimes show sometimes doesnt its quite clunky to hover over the visual and try to get the option and then click export. 

Any alternatives are also welcome - main issue to solve is allowing user to extract the data they filtered on the visual. I tried Power automate extract button but this doesnt let user set where the extract is saved/at least I couldnt figure it out.

[v-stephen-msft]

Hi @Anonymous ,

Could you tell me if your problem has been solved?
If it is, kindly Accept it as the solution. More people will benefit from it.
Or you are still confused about it, please provide me with more details about your problem.

Best Regards,
Stephen Tao

[v-stephen-msft · Accepted solution]

Hi @Anonymous ,

You could transform the DAX query of visual to the M query and use a R script to export the data.

Reference: Export data from All visuals at once

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , In the power bi service you have export summarize data- is that not working for the end-user?

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data#export-summarized-data

[Anonymous]

Hi @amitchandak, its working however its quite clunkly to get the option menu to stay, eg when user hover over the visual it will show and they will move their mouse to click it but it will disappear. I got few complaints and have yet to find a solution.