Forum Discussion
Helper IISome users can't export "Data with current layout" but some can?
It looks like some people can export "Data with current layout" but some users can't and have that option greyed out.
They are trying to export a matrix table. I'm able to export and most of users can it seems like but some users can't..
All my settings look correct and I can't wrap my head around why some users have that setting greyed out.
Does anyone know why this happens?
Current PBI & workspace settings for export:
Hi unicorns ,
The full admin portal can be accessed by global admins and users who have the Power BI administrator role. If you're not in one of these roles, you only see Capacity settings in the portal. For more information about the Power BI service administrator role, see Understanding the Power BI admin role.
About the admin portal - Power BI | Microsoft Learn
Best Regards
Community Support Team _ PollyIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
8 Replies
- unicorns
So the user who have that option greyed out doenst have any roles in the workspace. Im the PowerBi owner
Would logging in and out help?
Hi unicorns ,
It's important to note that if the Power BI admin portal settings conflict with the report settings for export data, the admin settings will override the export data settings.
Please check with the administrator whether the "export data" function is enabled for entire organization in the admin portal.
About the admin portal - Power BI | Microsoft Learn
Export data from a Power BI visualization - Power BI | Microsoft Learn
If it still does not help, please provide more details.
Best Regards
Community Support Team _ PollyIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- unicorns
where can I find those settings? https://msit.powerbi.com/admin-portal this link didn't show me those options
Hi unicorns ,
The full admin portal can be accessed by global admins and users who have the Power BI administrator role. If you're not in one of these roles, you only see Capacity settings in the portal. For more information about the Power BI service administrator role, see Understanding the Power BI admin role.
About the admin portal - Power BI | Microsoft Learn
Best Regards
Community Support Team _ PollyIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
It's probably related to this new feature: https://powerbi.microsoft.com/en-cy/blog/announcing-connected-excel-tables-from-power-bi/
It's weird, that the "live connection" choice has been put as the default in exporting, because the users who don't have "Build" access to the underlaying dataset are not able to export the data any more without changing the file format when exporting. This has caused a lot of questions.
