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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
isalcedo2002
New Member

Filtering a semantic model

Hello,

 

We have a project where we need to make dashboards for different people in the company.

The first one is for the top boss, who wants to see the general information for all the verticals.

The next ('child') is for the leaders of each vertical, and the final one for the end-client.

 

What we have done is in the first one, input all the data from our databases and for the second one (the child), import the semantic model of this first one and in this one add some excel files we have for the specific vertical, and the same for the next level which is end-client. The point in doing this is that, eventually the plan is to have a dashboard for each vertical (there are many), and a dashboard for each end-client (which are even more), and everytime we make a change, all the "children" and "granchildren" will have them as well and not have to do each change manually. 

 

The problem is we would like to filter the semantic model when importing it to the next powerbi, so that we only import the data from that vertical and the data from other verticals is not available.

Is it possible?

1 REPLY 1
lbendlin
Super User
Super User

Please read about Row Level Security (RLS) and about app audiences.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.