Hide tables when using personalize feature

Hi POSPOS,

I am Sorry to say that is no direct way to control which tables/queries are visible during personalization for specific users or pages.....the personalization feature shows all available datasets by default.

However you can try these workarounds you can implement without using Tabular Editor:

1-Create separate Power BI reports for each user group (Data Source Permissions)

• Report 1: Contains only Query 1 data + Page 1
• Report 2: Contains only Query 2 data + Page 2
• Use Row Level Security (RLS) or workspace permissions to control access

2-Try to hide Table from the Model

• Go to Model view
• Right click on tables you want to hide
• Select Hide in report view

Note: This doesnt completely prevent visibility in personalization but reduces clutter

3-Create a single query that uses parameters to control data visibility:

let
    Source = if UserPermission = "Group1" then Query1 else Query2,
    FilteredData = Source
in
    FilteredData

4-Combine Report with Dynamic Visibility

• Keep both queries but use measures to control visibility:

Page 1 Measure = 
IF(ISFILTERED('UserTable'[UserGroup]), 
    CALCULATE([YourMeasure], 'UserTable'[UserGroup] = "Group1"),
    BLANK()
)

•   Use bookmarks and selection panes to hide/show visuals based on user context

Page Level Security does not exist.  Consider using OLS - you can now set that up directly in Power BI. 

POSPOS 

I think you should consider splitting this report in two, include them in an app.

From your existing semantic model,

1.create two reports: Report 1 and Report 2 pointing to the same semantic model.

2. In your semantic model create two perspectives, one for report 1 and second one for report 2. Configure these perspectives in each report.

3. publish the two reports to your workspace and then include them into your app.

4. With the app navigation users can navigate to appropriate report. (you can also restrict it to specific users by using app ausidence groups .

this way, when they are in report 1 they will see query 1 fields when they click on personalize (as you have selected appropriate perspective report 1)

You can also do this power bi desktop thanks to TMDL view,

something like 

createOrReplace perspective 'My Sales Perspective'
    perspectiveTable 'Sales'
        includeAll: true
    perspectiveTable 'Customers'
        perspectiveColumn 'Customer Name'
        perspectiveColumn 'Region'
    perspectiveTable 'Products'
        perspectiveMeasure 'Total Sales'
        perspectiveHierarchy 'Product Category'

Connect on LinkedIn

Did I answer your question? Mark my post as a solution! If I helped you, click on the Thumbs Up to give Kudos. Proud to be a Super User!

Thankyou Ahmed-Elfeel, lbendlin, and tharunkumarRTK for your responses.

Hi POSPOS,

We appreciate your inquiry through the Microsoft Fabric Community Forum.

We would like to inquire whether have you got the chance to check the solutions provided by Ahmed-Elfeel, lbendlin and tharunkumarRTK to resolve the issue. We hope the information provided helps to clear the query. Should you have any further queries, kindly feel free to contact the Microsoft Fabric community.

Thank you.

Hi POSPOS,

We are following up to see if what we shared solved your issue. If you need more support, please reach out to the Microsoft Fabric community.

Thank you.

Hi POSPOS,

We wanted to see if the information we gave helped fix your problem. If you need more help, please feel free to contact the Microsoft Fabric community.

Thank you.