Control what users can see when using power BI datasets connection

[Nazdac911]

Hi all 

I have a workspcae that conatins a datamodel that contains all the tables , relations and measures . it depends on a dataflow.  

I want to allow users to connect to it through Power BI datasets connections: 

Now, users will be only capable to see the Report and Model tabs , not the Data tab. 

My question is: 

In the Model tab , how could I hide some tables from the user ,

I can choose hide tables , but then they will apper to the users as hidden tables !! this is not what I want , I want to hide them completely , so he cant see or use !! 

Thanks in adavnace 

Regards 

[v-binbinyu-msft · Accepted solution]

Hi @Nazdac911 ,

You need configure RLS, Please try below steps:

1. Import the dataflow in Power BI Desktop and set the RLS

2. Publish to Power BI Service, add the user to the corresponding role in the "Security" in the dataset

3. Share the dataset with corresponding user

For more details, you can read related document: Configure and consume a dataflow - Power BI | Microsoft Learn, Row-level security (RLS) with Power BI - Power BI | Microsoft Learn

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.