Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
Jano
Helper III
Helper III

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 3
Jano
Helper III
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.. 😉

RobbeVL
Impactful Individual
Impactful Individual

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

Jano
Helper III
Helper III

Push

 

Nobody an idea? 😞

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors