Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
Is it possible to export underlying data without Build permission for a user?
The user should be able to export the underlying data in adherence to the RLS filter. I don't want the user to be able to edit the report.
As far as I remember, it was possible to do this last year. Any changes since then?
Regards,
Saud Meethal
exporting data from a visual has no relation to build permissions (which are a prerequisite for "Analyze in Excel" - very different from export)
There are settings in the Power BI Desktop that allow the developer to limit exports to summary data only etc.
Hi @lbendlin ,
I have enabled the export underlying data setting under the report settings in pbix as well as enabled it at the power bi admin portal (from organization's O365 portal). But still the user with the Read permission is unable to export underlying data, only summarized is possible.
In some Power BI blogs I've come across, they've mentioned that underlying export will be enabled with Build permission only.
So is there anymore settings I can tweak to enable the export without letting the user change the report?
Regards,
Saud Meethal
Hi @Anonymous ,
For exporting underlying data, it requires a buid permission.
See the reference below:
These limitations and considerations apply to Power BI Desktop and the Power BI service, including Power BI Pro and Premium.
To export the data from a visual, you need to have Build permission for the underlying dataset.
Here is the related .reference:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.