Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
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.
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.
You can refer the following Microsoft documents that could also help you:
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.
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.
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.
You can refer the following Microsoft documents that could also help you:
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.
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
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,
Happy to help!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |