Forum Discussion
Does Excel honor PowerBI Role based security
I have a PowerBI report in Import mode. The report also has role based security defined either in a static manner or in a dynamic manner using UserName() function. Now I create an Excel Pivot Table report connected to the PowerBI DataSet. When I run the report will it honor the role based security definition ? Will the user see only that data which is permitted for that role ?
Hi.
As long as the Excel Workbook is connected directly to the Semantic Model, RLS should indeed still be applied.
_____________________________________________________
I hope my comment was helpful.
If your question was answered, please mark your post as 'Solved' and consider giving me a 'Thumbs Up'.
Find me on LinkedIn, Sessionize, or my blog Downhill DataHi, Sanjay_Shah
Thanks for Jonvoge's reply. As Jonvoge said, RLS still works in Excel, here are the test results.
Row-level security (RLS) with Power BI - Microsoft Fabric | Microsoft Learn
Power BI desktop:Service:
Excel:
Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
2 Replies
Hi.
As long as the Excel Workbook is connected directly to the Semantic Model, RLS should indeed still be applied.
_____________________________________________________
I hope my comment was helpful.
If your question was answered, please mark your post as 'Solved' and consider giving me a 'Thumbs Up'.
Find me on LinkedIn, Sessionize, or my blog Downhill DataHi, Sanjay_Shah
Thanks for Jonvoge's reply. As Jonvoge said, RLS still works in Excel, here are the test results.
Row-level security (RLS) with Power BI - Microsoft Fabric | Microsoft Learn
Power BI desktop:Service:
Excel:
Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum