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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Anonymous
Not applicable

Extract Data - Alternatives to Visual Header Option

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.

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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.

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

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

Anonymous
Not applicable

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
Super User
Super User

@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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Anonymous
Not applicable

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.

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.