Solved: Not able to export data to excel

Anonymous · ‎06-12-2019

Hi,

I can not export reportdata to excel from service.

Is there a temporarily bug in service?

dbabmg · ‎06-12-2019

We encountered this problem yesterday and another user pointed us in the right direction. It seems a new access right to data sets has been added, "Build".

Export rights, unless I am wrong, can now be determined in the .pbi file options settings, admin tenant settings, as well as data set permissions. Make sure that all of these allow for users to export.

RLS will still apply to anyone with build rights, or exporting data, regardless of where it says they can export data.

Let me know if this helps!

https://docs.microsoft.com/en-us/power-bi/service-datasets-build-permissions#build-permissions-for-s...

View solution in original post

Anonymous · ‎06-13-2019

Hi @Anonymous ,

I'd like to suggest to take a look at export feature document first to know the limitations:

Export data from visualizations

BTW, Power bi admin portal contains options to disable export features:

Administering Power BI in the admin portal

Regards,

Xiaoxin Sheng

dbabmg · ‎06-12-2019

We encountered this problem yesterday and another user pointed us in the right direction. It seems a new access right to data sets has been added, "Build".

Export rights, unless I am wrong, can now be determined in the .pbi file options settings, admin tenant settings, as well as data set permissions. Make sure that all of these allow for users to export.

RLS will still apply to anyone with build rights, or exporting data, regardless of where it says they can export data.

Let me know if this helps!

https://docs.microsoft.com/en-us/power-bi/service-datasets-build-permissions#build-permissions-for-s...