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
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
Hello v-lili6-msft,
thank you for this information.
What about the other questions?
- Will the connection obtained via "Analyze in Excel" be working PERMANENTLY or is it only TEMPORARY?
Can I modify the "SQL" command text even more to return the whole table/data set? Something like "Select * From ... " - (of course while respecting the RLS)- Is this approach reliable? Can you think of any downsides?
- Could someone exploit the connection to ignore the RLS?
I want to use this linked data table to create personalised reports in Excel - users will refresh the connection themselves and are supposed to get only "their" rows. (Power BI solution is also planned for later). Therefore I need the connection of this linked data table to be permanent and to ensure RLS filtering.
Warm regards,
Jakub
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