A user is viewing dashboards with data on an On-Premise Power BI Reporting Server. However, when this user exports to Excel, they get an empty Excel file. There are no issues with other users. What could be the reason for this?
I am sharing a screenshot below.(censored the content due to data security reasons.) It only contains text with the selected filters. Normally, the table exported to Excel consists of 10+ columns and 1000+ rows.
HI,@aspendus9
Regarding the issue you raised, my solution is as follows:
1.First, check to see if the user has insufficient role permissions in the workspace, and the Viewer role may be restricted.
Roles in workspaces in Power BI - Power BI | Microsoft Learn
2.Second, check if RLS is set for the user, as RLS will not only limit the visualization that the user can see, but will also cause the data to be empty.
Row-level security (RLS) guidance in Power BI Desktop - Power BI | Microsoft Learn
3.Finally, check if your administrator has restricted exports for that user.
Best Regards,
Leroy Lu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helpful resources
Power BI Monthly Update - May 2026
Check out the May 2026 Power BI update to learn about new features.
Data Days 2026 coming soon!
Sign up to receive a private message when registration opens and key events begin.
New to Fabric Survey
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
