Forum Discussion
External users unable to export to excel
Anonymous
This is nothing to do with licence. You would need to enable the option.
The Power BI Admin Portal provides the setting to restrict external users get a constrained read-only experience, meaning the externals can only view the report and dashboard but not allow to access to dataset including exporting.
Reference:
https://powerbi.microsoft.com/en-us/blog/azure-ad-b2b-guest-users-can-now-edit-and-manage-content-in-power-bi-to-collaborate-better-across-organizations/
https://docs.microsoft.com/en-us/power-bi/service-admin-portal
Paul Zheng
Don't forget to hit THUMBS UP and mark it as a solution if it helps you!
Thank you Paul for your immediate response. However i researched the same settings and came with the below fact that the users will need pro-license even after enabling the said amin tenant settings. Also, i checked with Microsoft support team and they also said that the external users will need pro-license. I wanted to make sure before asking my admin to on this setting.
Anonymous
I was reading your post and out of curiousity, I have 2 questions -
1. Any idea why it was working fine for your external users (without Pro license) some time back and why it stopped working recently?
2. Also, the setting "edit and manage content" is for editing the content, any idea why "export to excel" shouldn't work in this case?
Regards
Anonymous
Sorry for the sloppy sentence. What I meant is since you are already have your content in premium capacity, your external guests are able to access to the content even a with free account. You may reach others to verify.
Best,
PaulAnonymous Yes, ideally it should work as the workspace is in premium capacity but still the users are facing this issue. Recently, I got the information that the users are able to export in .csv but not in .xlsx which they were able to do so previosuly. This has been raised to Microsoft now and they are working on to troubleshoot it. Thank you for your vauable response.