Forum Discussion
Jano
Helper III
7 years agoExport 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
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
Helper 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.. ;)
- Jano
Helper III
Push
Nobody an idea? :(
- RobbeVL
Impactful Individual
Are they Pro users?
This is I Pro feature if I'm not mistaking.