cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
pradeep467 Regular Visitor
Regular Visitor

Issue with relationship between tables using Security

Hi,

I am observing a strange issue in PBI,I have a security table that is at storenbr and userid level which I am joining to ,y type 1 store dimension which in turn joins to type 2 store dimension whihc joins to Facttable. I created a role group and added users to that and also added the necesary filters.Issue is when I do a view as role, the Secuirty 

table filters out only the stores that user has access to which in turn filters my Store dimension type 1. But the type 2 store dimension which is joined to type 1 is getting some additional stores in addition to the actual stores. Please advise as to where could be the issue.

 

pbi_img.png

 

1 REPLY 1
Super User IV
Super User IV

Re: Issue with relationship between tables using Security

Hi there

I would suggest that you change your model to reflect a traditional star schema which will make it a lot easier to work with.

Here is a new whitepaper from the Power BI CAT team explaining the Star Schema:
https://docs.microsoft.com/en-us/power-bi/guidance/star-schema




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






Power BI Blog

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors