Forum Discussion
Report Table Export Data option - no data downloaded
Hi Anonymous
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!