Have each Page have Different Relationship

[stack23]

How do I make it so in PowerBI Desktop, each page has a Different Set of relationships?

Example: Page 1 will only allow users to look at Customer Table.

Page 2 will only allow users to look at Products Table,  and certain related tables.  

Page 3 will only allow users to look at Shipping Table,  and certain related tables.  

Each page will be confined to have 3 different relationship diagrams.  

User in one page, will not be able to see other relationships or star schema.

* So essentially, Relationship diagram per page.

[MattAllington]

You can’t see the relationships from a page anyway. There is 1 data model per workbook. You can’t have a differenct data model structure per page. Just creat another workbook. 

[stack23]

yeah, we wanted to have our client read another relationship in another page, rather than opening another workbook, more like a client interface thing,

[v-cherch-msft · Accepted solution]

Hi @stack23

It seems you may have row-level security. Below is the document for you.

https://docs.microsoft.com/en-us/power-bi/developer/embedded-row-level-security

Regards,

Cherie

[stack23]

nothing about security, we just want different power bi tabs to have different data, thats it