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.

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

Hi amaaiia 

 

Thanks for using Microsoft Fabric Community.

Yes, it is possible to create data access rules in Microsoft Fabric to restrict access to user data in a Lakehouse table consumed by Power BI. Please refer to the video that explains this topic in detail, including workarounds for limiting access to specific user data in Power BI reports. This video demonstrates a step-by-step approach to implementing data access rules, specifically addressing the use case you mentioned. 

You can find it here: https://www.youtube.com/watch?v=MdmPjZAV9I8.

 

I hope this information helps. Please do let us know in case if you have any further questions.

 

Thanks.

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.