Forum Discussion

Jano's avatar
Jano
Icon for Helper III rankHelper III
7 years ago

Export to Excel not showing up for users

Hi guys,

I got a master dataset A in an admin workspace X.
I created a new pbix using dataset A as the source and published it to workspace B for my accounting team.
Now, they need to download certain data from that report in workspace B to excel, but the button to export data to excel is not showing up for them.
I, as an admin and owner of all datasets and workspace can see that button.

I didn't define any RLS yet or other security groups in power BI / O365.
I turned on the permission to export summarized and underlying data in the pbix files.
I checked the global permission to allow export data in the power BI service, it's activated for whole organization.
I tried all workspace permission roles for that accounting user, not even with admin it seems to work.

What did I forget to make this work?
I hope you guys can help me!

Best regards,
Jano

3 Replies

  • Jano's avatar
    Jano
    Icon for Helper III rankHelper III

    Pretty late but I found the permission missing.

    They are pro users but need the "build" permission for that master dataset in order to export from reports to excel.. ;)

  • RobbeVL's avatar
    RobbeVL
    Icon for Impactful Individual rankImpactful Individual

    Are they Pro users? 
    This is I Pro feature if I'm not mistaking.