Users can't export data anymore on a published report

[cailloux]

Hi,

what kind of option I have to choose if I want to allow user to export data in a published report but prevent them to access the right panel (vizualisation and tables) ?

I've found how to hide the visual header before publishing, but since then, viewers can't export data.  Maybe its an option I changed in another location (in the https://app.powerbi.com/groups) ?

Thanks a lot !

[Maddy99]

Currently there is not a solution to this. with disableing the headers also the export function disapeard. 

on the idea forum there is a suggestion to control the header per visual. https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/33566500-allow-visual-header-cont.... maybe this could work.

or as an out of the box solution, clik on the "analyse in excel" option. it is not perfect but maybe it work for you. 

[prihana]

Isnt the right panel is by default disabled when you share the report?

[cailloux]

Hi, thanks for the reply :

Yes, the right panel has been disabled :

- Before publishing I choose  "hide the visual header"

In the app.powerbi.com/groups I choose "user can only see the Power Bi content" (its in french below) :

Is there a way to prevent edition but to keep the export data option in the visuals without republishing the entire model (this option) :

Should I do it without republishing the entire report ? I've tried to change these options without success (in one case it show the right panel and people can change everything - in another users can't export useful data in the visuals),

Thanks a lot !

[cailloux · Accepted solution]

Thanks,

I didn't see the reply before, there is an exemple of report published without the full right panel options but with exports capabilities (I have delete some graphs) :

 

Thank you very much !

[Maddy99]

in this last picture everything is a you want?

no edit options for the user, like deleting or changing, but they can still export. 

[cailloux]

Exactly !

[cailloux]

Hi,

So what kind of option do I need to choose to have this publication result for user (no edit option - but eport data ok) ?

Thanks !

[Maddy99]

You can disabled the edit option by ad users as a member of the workspace and slecect the "Members can only view Power BI content"and still make the headers visiable.  

the only thing user can change are things that are only visable for them. like filters or sort tables and charts. but those changes are not visable for the other viewers.