Export to Excel maintaining RLS

[Jonas1]

Hi, 

I am gonna share a report with a large number of users in my organization using RLS. 

However, it is important that they are able to export one particular matrix to excel easily, at the same time as the access control I have set up is maintained. Has anyone managed to do this in a smart way? 

Currentely everyone will need to export using the three dots above the visual, but I would love to rather be able to do a one time export as you can do with the "analyze in excel" option, at the same time as access controls are maintained and depends on who opens the excel document. 

Should be possible to do right??

[v-xicai · Accepted solution]

Hi @Jonas1 ,

To export the data from a visual, you need to have Build permission for the underlying dataset.

While the RLS will be applied to read-only members. If you have configured the app workspace so that members have edit permissions, the RLS roles will not be applied to them. Users will be able to see all of the data.

Your demand is a good idea, while it is not supported to implement in Power BI currently. You can post your new idea here https://ideas.powerbi.com/forums/265200-power-bi-ideas , to improve the Power BI.

It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.