A Way to Export Underlying Data in Power BI

Power BI is one of the most powerful data visualization tools by Microsoft, offering users the flexibility to explore, visualize, and share insights. But when it comes to exporting underlying data, many users face limitations depending on their environment — Power BI Service, Report Server, or Desktop.

In this guide, we’ll explain who can export data, how to enable underlying data export, and how to troubleshoot when the option is greyed out.

Who Can Export Data from Power BI?

Power BI allows data export for users with sufficient permissions in their workspace. If you can export data from a Power BI visual, you already have the necessary rights.
However, if the export option is disabled or greyed out, you might not have editing or export permissions set by your Power BI administrator.

To check your access:

• Hover over the visual and see if the “Export data” option is active.
• If not, contact your Power BI dashboard owner listed under the report title.

Your Power BI Data Security Is Always Protected

Power BI ensures that your data remains protected during export. Administrators can apply Microsoft Data Protection sensitivity labels to control how data is exported or shared. These sensitivity labels ensure that only authorized users can access exported files, maintaining enterprise-level compliance.

Additionally, Microsoft Defender for Cloud Apps allows admins to:

• Track user activity and data access
• Perform real-time risk analysis
• Set restrictions for exporting sensitive information

This ensures secure data handling even when exporting data to Excel or other tools.

How to Export Underlying Data in Power BI

To export underlying data successfully, follow these steps:

1. Enable Export Settings in Power BI Desktop
   • Go to File > Options and Settings > Options
   • Select Current File > Report Settings
   • Under Export Data, enable:Allow end users to export summarized and underlying data
2. Troubleshoot if Underlying Data Is Greyed Out
   If you still can’t export data:
   • Create a calculated measure using a simple aggregate function such as SUM, MIN, or AVERAGE.
   • Add this measure to your visual.
   • This will “unlock” the underlying data export functionality.
   • Hide the measure column if needed and republish your report.
     

This simple workaround lets you export both summarized and detailed data from Power BI visuals without losing access to important data points.

Why Exporting Underlying Data Matters

Exporting underlying data gives analysts and decision-makers granular visibility into their datasets.
It enables:

• Detailed offline analysis in Excel
• Auditing and validation of Power BI visuals
• Sharing insights securely with stakeholders

Whether you use Power BI Service, Desktop, or Report Server, this feature ensures full data transparency and flexibility in analytics.

Final Thoughts

Power BI continues to enhance its data export and security features, making it easier for users to handle underlying data safely.
If you face issues with exporting data, check permissions, enable the correct export settings, or use the aggregate function trick to bypass limitations.

At Infometry, our Power BI experts specialize in data visualization, dashboard development, and secure Power BI integration for cloud and on-prem environments.

Contact us to optimize your Power BI performance or explore our Data Visualization and Power BI solutions.