Leverage RLS with Direct Lake in Microsoft Fabric without access to OneLake

You don't want to give your users access to OneLake or the Lakehouse/Warehouse directly, but you still want to use Power BI Direct Lake in Microsoft Fabric. Patrick shows you a way to get this done!
Direct Lake Overview
learn.microsoft.com/fabric/ge...
📢 Become a member: guyinacu.be/membership
*******************
Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.
🎓 Guy in a Cube courses: guyinacu.be/courses
*******************
LET'S CONNECT!
*******************
-- / guyinacube
-- / awsaxton
-- / patrickdba
-- / guyinacube
-- / guyinacube
-- guyinacube.com
**Gear**
🛠 Check out my Tools page - guyinacube.com/tools/
#MicrosoftFabric #PowerBI #GuyInACube

[@spontelloable]

Built out an example following this method using a Service Principal for the Authentication method to avoid having the connection being tied to a specific user account and it worked great!

[@stevensiligato2429]

Any chance you have documentation on this? I have followed everything to the t online and keep getting errors about a "null" value.

[@zhihaowu208]

Thank you for the clear explanation!

[@marcelo1689]

We would like to implement RLS that would filter data based on the user id. We can do that when we share Reports to the final user. What we need now is RLS based on user id when we share data to power users.

[@rahulmaurya9444]

Q: Is there any chance we can set the RLS in dataflow or lake house without giving them any workspace access

[@tinaflemons263]

What about granting access to a group? Does it work the same way?

[@PalantirM]

What about RLS through a table? Does it fall back to direct query, have I understood correctly ?

[@akki4718]

Is postgre SQL doesn’t support deployment pipeline in power bi? As data source is disabled to change

[@josenunez5983]

I have access to a Azure Synapse analytics account and the DataBase I need to query the data is serverless, I need to connect to it from NodeJS application, is it achievable? Also when I try to connect to the serverless database from Azure Data Studio the database is not there.

[@damn68]

OMG. I am jumping right now. 🎉. I have been looking for this for years. Not talking about all the consulting fees without solutions

[@Splinta100]

bro fabric hasn't been out for years. what u talking about?

[@markk364]

MS Sales Channel in a Cube