Forum Discussion

amaaiia's avatar
amaaiia
Icon for Skilled Sharer rankSkilled 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.

frithjof_v's avatar
frithjof_v
Icon for Community Champion rankCommunity Champion
2 years ago

Hi amaaiia 

 

I think you have some options:

 

  • If you want to use Import mode Power BI semantic model, you can set up the Row-Level Security (RLS) in the Import mode Power BI semantic model. For me, this would be the easiest way to implement RLS. This is the traditional way of setting up RLS in Power BI, and can be made simple or more complex.
    Here are some videos which touch upon that:   Guy in a Cube           Radacad
    And some blog posts:    Static RLS             Dynamic RLS

 

  • 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.

 

  • If you want to use DirectQuery mode (maybe not ideal for performance), you can set up Row-Level Security (RLS) in the SQL Analytics Endpoint. This is shown in a part of the YouTube video in the previous reply.