HI - if you look in the Tenant Setting for Exporting then Export Data, there is an option Apply to Specific security groups, if you setup a security group within Azure AD, you then add that and then only members of the group can use the export option
Thanks that would work but unfortunately I am not using Azure.. I have very little knowledge on cloud.
Isnt there another way to either restrict the option of exporting underlying data (leaving only the summarised there) or having control over what this underlying data will include (pretty much exclude some columns that I do not want users to access)
I worked with my O365 Admin and was able to create a security group that prevents users from exporting data. Ideally, I want these users to have the ability to export data, just not the "underlying data" export. As far as I can tell, the only solution Microsoft has is to hide the tables/columns in Power BI desktop and then publish to cloud. If a user accidentally selects the underlying data export option then the hidden tables/columns will not be returned. However, I have an analyst team that does all our content creation in the cloud and need the tables/columns visible in the Power BI service to create content.
So there's a simpler way.
Go to your workspace where the report is published. Go to "REPORTS" and then under ACTIONS where you see all of those little icons, click on the gear symbol. Under Export Data there is an option to do summarized, none, or summarized and underlying.
Choose the one you want and voila! Even if you are an admin to the workspace, if you go into the report you can't export underlying. It'll be grayed out.
It's good for that report. Picture below: