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

The Fabric Community site will be in read-only mode on Monday, Feb 24 from 12:01 AM to 8 AM PST for scheduled upgrades.

Reply
RD1965
New Member

Report Table Export Data option - no data downloaded

Hi,

 

I have users of PBIX reports that download the data of a table on the report using the Export Data option.  Sometimes only the headers are downloaded (using Summarized data option) to .xlsx file., other times all the data is downloaded.

 

All users have the same level of access and we don't have any Row-Security on the report.

 

3 REPLIES 3
Poojara_D12
Super User
Super User

Hi @RD1965 

If users are experiencing inconsistent behavior when exporting data from a PBIX report—sometimes getting only headers and other times getting the full dataset—several factors could be at play. Since all users have the same access level and there is no Row-Level Security, the issue is likely related to model relationships, visual-level filters, or aggregations affecting the export. When using the "Summarized data" export option, Power BI exports only the visible data in the table or matrix, which means filters applied in the report can lead to empty results. Additionally, if a measure or calculated column is used and doesn't resolve correctly due to missing context (e.g., a blank result in the visual), Power BI may return only the headers. Another possibility is cache inconsistencies—refreshing the report before export might yield different results. Users can try exporting using the “Underlying data” option (if enabled), which bypasses some visual filters and exports raw table data. Checking the report’s filters, data model structure, and enabling verbose logging in Power BI Service might help diagnose the issue further. Let me know if you need help troubleshooting specific scenarios!

 

Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a "Kudos"

Kind Regards,
Poojara - Proud to be a Super User
Data Analyst | MSBI Developer | Power BI Consultant
Consider Subscribing my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS
powerbidev123
Responsive Resident
Responsive Resident

Hi @RD1965 try thr below solutions and let us know

 

1. Ask users to clear all filters before exporting or check interactions in Edit Interactions mode.

2.Try switching to Underlying Data export (if allowed) to see if more data is available.

3.Ensure the correct export permissions are set in the Power BI Service under Tenant Settings.

4.Try exporting the same table under different user accounts and compare results.

Thanks for Feedback - Using PBIRS, so tenant setting - I believe - are not relevant.

Users do not apply any filters before Export and can rerun the report and Export the data and it sometimes does download.  Nothing appears to be different..

 

This flaky behaviour is annoying users & me and undermines users ability to trust the data/reports.

 

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

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

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

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