Forum Discussion
Export to Excel Empty Result Problem
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 c...
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.