Forum Discussion
Export data from Power BI online
I have a user that is needing to export summarised data from a visual in Power BI online.
I am able to click the elipsis above the matrix and export summarised data:
However, the user in question is not. He doesn't even have the option:
When looking at the actual pbix settings it is set to allow export:
I don't understand what could be blocking this. In classic Microsoft fashion, all the options are so heavily buried in context menus I don't even know where to look.
Can someone point me in the right direction?
5 Replies
For more information, this is what the user sees in the workspace. He can confirm that in the 2nd report he has the ability to export data, or analyze in excel. But the 1st report he cannot. Take note of the excel symbol that is greyed out. Surely there is a setting somewhere that can change this.
It seems like the user doesn't have the permisison to build new content using the underlying dataset.
When the content owner shares the content to this user, the "Allow users to build new content using the underlying datasets" was not checked.
To fix it, the owner can grant build permission to this user through manage permissions page of this underlying dataset. This documentation has more context https://docs.microsoft.com/en-us/power-bi/service-datasets-build-permissions#build-permissions-for-shared-datasets
Thanks for your reply.
I've already ensured that all of these boxes are ticked. So there is something else at play here. I'm very confused.
