Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I had changed the permissions for users viewing our reports so they did not have "Build" permissions. We did this so they could not build reports off of our datasets since they could have confidential information. However, since doing this the option to export data from any of the visuals is gone. After doing some digging around I tested out adding build permissions back to the users and the export button was available again. Is this a bug in Power BI? They should not have access to all underlying datasets just to be able to export information from a visual.
Totally agree with OP, this is a weird design choice. There is a idea posted that this should be separated, where you can vote on the change:
Sadly it's not a bug because they have it in their documentation. It's just stupid.
Has anyone found that this is something that's started happening recently? We have reports that some users can export from and others can't. Permissions are the same on the app for both users, the only thing that's different is when they were added in permissions to the all.
This started occuring in June when they released permissions on Datasets (adding the build permissions)
They also granted users the ability to see all the data in the dataset if you shared your report with users before June
Hi @StewartHunterAc,
This is a different issue from the topic of this thread. Please post a new thread withe detail information, our team members will investigate it and reply in your thread.
Best Regards,
Qiuyun Yu
Hi @MEEnergy,
It's a limitation. From this document, you can see:
To export the data from a visual, you need to have Build permission for the underlying dataset.
Best Regards,
Qiuyun Yu
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.