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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
EshaanG
Helper I
Helper I

How to export data from Table/Matrix Visual

Hello, I am trying to export data from a Table/Matrix Visual in a report published on PowerBI Service. However, I do not see a option to export the data when clicking on the options (three dots). I can see the option when I go into edit mode but not in reading view.

 

Can anyone help? 

 

Capture.PNG

1 ACCEPTED SOLUTION
v-yingjl
Community Support
Community Support

Hi @EshaanG ,

You can check these two solutions:

1.When you are the Global admin or Power bi admin, click the settings on the right corner and find Admin Portal menu. In Admin Portal menu, select Tenant settings. Under Export and sharing settings, find Export data option and enable it.admin portal.png

If you have no permission in Admin portal, please contact your administrator and enable this option.

 

2.Another situation is in report settings, under Export data option sets None, you can change it into summarize data or summarize data and underlying data.

report settings.png

You can refer the following Microsoft documents that could also help you:

  1. https://docs.microsoft.com/en-us/power-bi/consumer/end-user-export
  2. https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data

 

Best Regards,

Yingjie Li

 

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

3 REPLIES 3
v-yingjl
Community Support
Community Support

Hi @EshaanG ,

You can check these two solutions:

1.When you are the Global admin or Power bi admin, click the settings on the right corner and find Admin Portal menu. In Admin Portal menu, select Tenant settings. Under Export and sharing settings, find Export data option and enable it.admin portal.png

If you have no permission in Admin portal, please contact your administrator and enable this option.

 

2.Another situation is in report settings, under Export data option sets None, you can change it into summarize data or summarize data and underlying data.

report settings.png

You can refer the following Microsoft documents that could also help you:

  1. https://docs.microsoft.com/en-us/power-bi/consumer/end-user-export
  2. https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data

 

Best Regards,

Yingjie Li

 

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

Anonymous
Not applicable

Hi,

 

This is not helping, i would like to export the complete matrix which is built in Visualisation (in PowerBI Desktop) as is into excel. The Summarize data and Underlying data doesn't help because due to excel limitations of handling huge data we develop in PowerBI, again if we are using the excel to rebuild it then there is no use of using PowerBI.

 

Regards,

Suhas

ibarrau
Super User
Super User

Hi. We should check something first. The export option can be remove from specific report or from the whole tenant. Go to the report settings and check the Export Data option. You can follow this post to check it:

https://blog.ladataweb.com.ar/post/611048296911339520/powerbi-configuración-de-informe

 

If you have that option "on", then you'll have to contact the Power Bi Administrator to ask for exporting data. It's an option in the admin portal under tenant settings.

 

Regards,


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

Happy to help!

LaDataWeb Blog

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.