Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us at FabCon Vienna from September 15-18, 2025, for the ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM. Get registered

Reply
Dhacd
Resolver III
Resolver III

Is Fabric object level restriction or role level security coming soon?

Hi Fabricators,

I am working on a data warehouse/ Power BI reporting project for a client using Microsoft Fabric. We are using a live connection from Power BI to a dataset that we created from the lake house.

Everything has been going smoothly until we got to the point of giving access to the end users. Since it is a live connection, we need to provide them with viewership access to the lake house. However, there is no object-level restriction or role-level security available in Fabric, so the report viewers would be able to see the whole chunk of data inside the lake house, even though we need to keep some restrictions.

On the report side, to work around this, we have created multiple reports in Power BI and filtered them on the front end. We then created an app with different audience sets and added the corresponding filtered report to each end-user set.

I understand that Fabric is still not generally available, but I am wondering if there is any plan/roadmap available to add object-level restriction or role-level security in the near future. This is a critical feature for any data warehouse platform, and it is kind of disappointing that it is not yet available in Fabric.

I would be grateful for any information on this topic.

Thank you,
Atma
5 REPLIES 5
Anonymous
Not applicable

Hi @Dhacd - Thanks for using Fabric Community.

I can find we have Object Level Restrictions in MS Fabric. 
Inorder for more details you can refer this document Link .

I hope this helps, do let us know if you have further queries.

Anonymous
Not applicable

Hello @Dhacd 
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 .

Anonymous
Not applicable

Hi @Dhacd ,

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 .

Hi, Thanks for the Reply,

I saw the release on  OLS and RLS for SQL Endpoint but not for lake house and fabric dataset.

What really happening on my end is, that when I am trying to share a power bi report( that is using fabric data set as backend) with a user, On his side he is getting an error saying the lake house is not shared with him. So when we share the lakehouse with him. What happens is he can see the entire data in the lakehouse, I have added a report-level filter so that he has limitations in seeing the data which is not his. But now he can query and get the data that should be hidden from him.

I hope you understand the problem. If not let me know the comments and I will answer.

Anonymous
Not applicable

Hi @Dhacd ,

Can you please share complete details and explain things clearly.
I would like to understand what you are trying to do exactly.
So i can help you in providing a solution on your issue.

Helpful resources

Announcements
May FBC25 Carousel

Fabric Monthly Update - May 2025

Check out the May 2025 Fabric update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.