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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Some13lse
Frequent Visitor

Restrict data shown in composite model

I am trying to creata a solution which I think many people/companies face.
We have a DWH and want to create Master semantic model for Self Service BI. A single source of the truth so we don't have to manage multiple semantic models when there are changes or extensions.

We have multiple teams who should be able to access the same tables, but data for team A (having their own workspace) should only be accessable from their workspace. The same goes for the other teams.
We have tried the following to implement this:
1) Created a Master semantic model in a restricted Workspace. Created a composite model in worspace Team A (based on the Master semantic model) and tried to restrict the data to just Team A. This failed because we see no option to restrict the data in the composite model just to Team A related data.
2) Implement RLS for the teams on Master semantic model. This fails because we have employees who are member of multiple teams. Also some employees have a contributer role so they can build reports. In that case for members who are member of multiple teams, data from other teams will bleed into the reports of Team A.

Any suggestions on how to implement this in a propper way?

1 ACCEPTED SOLUTION
aj1973
Community Champion
Community Champion

Hi @Some13lse 

Best way for one source of truth and reusable data in Power BI service is to create Dataflows. 

Introduction to dataflows and self-service data prep - Power BI | Microsoft Learn

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

View solution in original post

2 REPLIES 2
aj1973
Community Champion
Community Champion

Hi @Some13lse 

Best way for one source of truth and reusable data in Power BI service is to create Dataflows. 

Introduction to dataflows and self-service data prep - Power BI | Microsoft Learn

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Thanks for your quick reaction and link @aj1973 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors