Forum Discussion

amaaiia's avatar
amaaiia
Skilled Sharer
2 years ago
Solved

Row level access for Lakehouse tables

Is it possible to create data access rules in a Lakehouse table that is going to be consumed by Power BI? If I have a table with user data with one of the columns user_id, which by architecture I nee...
data engineering
  • frithjof_v's avatar
    frithjof_v
    2 years ago

    If you want to use Direct Lake mode Power BI semantic model, you can set up the Row-Level Security (RLS) using an external tool like Tabular Editor or SSMS. This is shown in this YouTube video and written about in this blog post. I think this will be possible to set up directly in Fabric (without external tool) in the future.

v-cboorla-msft's avatar
v-cboorla-msft
Microsoft Employee
2 years ago

Hi amaaiia 

 

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.
In case if you have any resolution please do share that same with the community as it can be helpful to others.
Otherwise, will respond back with the more details and we will try to help.


Thanks.

v-cboorla-msft's avatar
v-cboorla-msft
Microsoft Employee
2 years ago

Hi amaaiia 

 

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others.
If you have any question relating to the current thread, please do let us know and we will try out best to help you.
In case if you have any other question on a different issue, we request you to open a new thread.


Thanks.