Showing results for 
Search instead for 
Did you mean: 
Helper II
Helper II

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,
Helper II
Helper II

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.. 😉

Impactful Individual
Impactful Individual

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

Helper II
Helper II



Nobody an idea? 😞

Helpful resources

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!