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.

amaaiia's avatar
amaaiia
Icon for Skilled Sharer rankSkilled Sharer
2 years ago

I'm using DirectLake mode, as I've read this is just for DirectQuery mode. Is it an available solution integrated in Fabric for DirectLake mode?

frithjof_v's avatar
frithjof_v
Icon for Community Champion rankCommunity Champion
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.