Forum Discussion
RLS - Analyze in Excel connection
hi , jdusek92
1. It is PERMANENTLY, You can use it next time you open it, also it will verify your account.
3. reliable, although I can't find the relevant documents for you, Unreliable Microsoft won't use it.
4. Impossible, Security has always been a major concern for Microsoft.
Best Regards,
Lin
HI, jdusek92
Excel is Connected Live to the Power BI Model in the Service.
and current RLS filter effect only works for read permission users, if you are dataset owner or you have edit permission, then RLS not works.
http://radacad.com/power-bi-and-excel-more-than-just-an-integration
https://community.powerbi.com/t5/Service/RLS-Analyze-in-Excel/td-p/222826
Best Regards,
Lin
Hello v-lili6-msft thank you for your reply.
what you say is completely clear to me and is not a part of my question - RLS works as expected - owner sees all and other users assigned to RLS role sees filtered data.
My question is about thr linked data table obtained via drilling through OLAP pivot table (created by Analyze in Excel)
Warm regards
Jakub
This is how I get the linked table I have questions about:
hi, jdusek92
thr linked data table obtained via drilling through OLAP pivot table (created by Analyze in Excel) is couldn't achieve like "Select * From ... ". for you need to sign in Office 365 account and it also will be verified by RLS.
Best Regards,
Lin
