Yooo Patrick! Man, I run across this and I have to say I solve this using the method 2 Fact tables, one with 2 relations and one with 1 relation (shown in 4:17). Seeing the Role-Playing Dimensions way I was like "nooooo, Please don't stop the video here, there is a better way!", and in the end I have to say, "Man, you cloud make this video 8 months ago... It would make my like so much easier". Haha Thanks and great video.
Can you make a video on RLS when two tables cannot be connect via one to one relationship? I currently use something like this : Contains(SECURITY,SECURITY[USERNAME],USERNAME(),SECURITY[ColName],DATA[ColName],SECURITY[Datatype],"SecuredDataType") SECURITY table contains information about who has access to certain info and Data is the data related to that info. I cannot have one to one or one to many relationship because of the nature of data.
Hi, I have a live connection to SSAS and a measure that return text , but it seems disenable when I try to use it as field value in order to do Dynamic the text button.
Hi Patrick. Love watching your videos... you always teach me something. Need your help on a new challenge. We have implemented about 20 RLS roles. two-thirds of them are different sales types. We also have geo filters and a few other filters implemented. Our challenge is that users are comparing their results with each other, but due to the differences in RLS roles they are coming up with different values (intentionally). We would like to create a text-box/visual of which roles the user has so it is easy for the support team to indicate where/why there are differences. Any help would be appreciated.
When I implement this in SSAS Tabular, connect to it with Excel and I select a column from the secured fact table WITHOUT selecting a measure in the report, it gives me a cartesian product including all the column values which were supposed to be invisible for the user. Is there a way to prevent this, for instance by inclusing a measure from the secured fact table in de DAX RLS Filter expressen?
Hi Patrick, appreciate and like the vids thanks. However I'm confused on this one, i may of misunderstood (I accept that's highly probable here) however didn't you just end up linking the RLS to the fact table? which you also point out at the beginning not to do.
Great video!!! How would you handle security in this scenario The account manager for Denmark is allowed to see all shipments if either "country of origin" is Denmark OR "country of destination" is Denmark ? So each fact row (Shipments) have those two Country dimensions attached. So normally if i restrict the user on "country of origin" to be Denmark it will also filter out all those shipments where "country of destination" is Denmark but "country of origin" is for example Germany
Hey Patrick. Thanks for this video. Q : Can you help creating an RLS if I have to filter two dimensions at the same time . This is very important. I have country in one dimensions and department in one dimension. I need to filter the facts by a person of department and specific country. I hope you see this comment.
I have a base of 400 clients, will I have to create a license for each one to use the rls filter? the frontend filter is not secure and ends up allowing you to send any value. Help !! =X
@@Maths-learn123 If you enter the workspace you want to extract the data, in the report ellipsis on the right of the name, there is an option "View usage metrics report" that generates a report with usage metrics, you can leave it just like that or use the data to create another report, analyze it in excel, etc.
Hi Guys , small challenge for me can you pls help. I want to compare rankings of 2 years and want represent with some conditional formatting showing the difference to previous year ranking . May sound stupid but that’s my requirement .
Yooo Patrick! Man, I run across this and I have to say I solve this using the method 2 Fact tables, one with 2 relations and one with 1 relation (shown in 4:17).
Seeing the Role-Playing Dimensions way I was like "nooooo, Please don't stop the video here, there is a better way!", and in the end I have to say, "Man, you cloud make this video 8 months ago... It would make my like so much easier".
Haha Thanks and great video.
This is fantastic!!
Can you make a video on RLS when two tables cannot be connect via one to one relationship? I currently use something like this :
Contains(SECURITY,SECURITY[USERNAME],USERNAME(),SECURITY[ColName],DATA[ColName],SECURITY[Datatype],"SecuredDataType")
SECURITY table contains information about who has access to certain info and Data is the data related to that info.
I cannot have one to one or one to many relationship because of the nature of data.
Yoooo thank you very much for answering my question.
All you guys built up an awesome community
Hi Patrick,
Love your vids. Just wondering how do you apply RLS to a PowerBi paginated report that uses a PowerBI dataset??
Good one.
Neat solution.
Gud one Pat!
Nice!
Can u pls explain RLS for many to many relationship?
Hi, I have a live connection to SSAS and a measure that return text , but it seems disenable when I try to use it as field value in order to do Dynamic the text button.
Nice one
Hey Patrick, need to show images based on date with date wise in collage image chart
can you explain about these
Hi Patrick. Love watching your videos... you always teach me something. Need your help on a new challenge. We have implemented about 20 RLS roles. two-thirds of them are different sales types. We also have geo filters and a few other filters implemented. Our challenge is that users are comparing their results with each other, but due to the differences in RLS roles they are coming up with different values (intentionally). We would like to create a text-box/visual of which roles the user has so it is easy for the support team to indicate where/why there are differences. Any help would be appreciated.
Does the RLS also work with a many to many relationship, when several persons should be able to see a certain territory?
When I implement this in SSAS Tabular, connect to it with Excel and I select a column from the secured fact table WITHOUT selecting a measure in the report, it gives me a cartesian product including all the column values which were supposed to be invisible for the user. Is there a way to prevent this, for instance by inclusing a measure from the secured fact table in de DAX RLS Filter expressen?
Hi Patrick, appreciate and like the vids thanks. However I'm confused on this one, i may of misunderstood (I accept that's highly probable here) however didn't you just end up linking the RLS to the fact table? which you also point out at the beginning not to do.
Yeah, and also, if there are multipe emails having access to same region, the relation will end up being many to many, which would not be ideal...
Great video!!! How would you handle security in this scenario
The account manager for Denmark is allowed to see all shipments if either "country of origin" is Denmark OR "country of destination" is Denmark ?
So each fact row (Shipments) have those two Country dimensions attached.
So normally if i restrict the user on "country of origin" to be Denmark it will also filter out all those shipments where "country of destination" is Denmark but "country of origin" is for example Germany
If you have a dim country table you can make RLS for Denmark ?
Hey Patrick. Thanks for this video.
Q : Can you help creating an RLS if I have to filter two dimensions at the same time . This is very important.
I have country in one dimensions and department in one dimension. I need to filter the facts by a person of department and specific country. I hope you see this comment.
Hey Santosh! Have you found solution for this, I am stuck with this same issue 😢
Cool. So you basically create a hidden dimension that is specifically for RLS?
I have a base of 400 clients, will I have to create a license for each one to use the rls filter? the frontend filter is not secure and ends up allowing you to send any value. Help !! =X
Hey, Patrick. Is there any way to see who has accessed my report recently? Or even the access history?
You can extract the usage metrics from the service
@@MijalisMendiz can u explain clearly
@@Maths-learn123 If you enter the workspace you want to extract the data, in the report ellipsis on the right of the name, there is an option "View usage metrics report" that generates a report with usage metrics, you can leave it just like that or use the data to create another report, analyze it in excel, etc.
Hi Guys , small challenge for me can you pls help. I want to compare rankings of 2 years and want represent with some conditional formatting showing the difference to previous year ranking . May sound stupid but that’s my requirement .
WHEN WILL PBIRS SUPPORT MANY-TO-MANY?!!!!
Most likely never. Cloud is the way.
First