There clearly was one treatment for do this: you have got to play with Object Level Coverage (OLS) in your dataset

Along these lines:

If you have sensitive and painful studies on your Electricity BI dataset you may prefer to avoid certain users watching the details in some articles otherwise steps. It is far from adequate to prohibit those people methods or columns from the account or even to cover-up him or her, since there will always be indicates getting enterprising profiles observe study they really should not be permitted to come across. Thank goodness there is now an effective way to carry out one to statement linked to a great dataset that have OLS while having it display screen additional columns and actions to help you users with different permissions.

Now let’s say your address and you will bonus investigation is to only become noticeable to Hr and everyone else is to only be ready observe this new names and you will sales beliefs. Whenever i told you, the only way to do this would be to would a role that uses OLS so you can deny access to the new target and you may extra columns. Gilbert Quevauvilliers have a great post showing just how to created OLS playing with Tabular Publisher here so i wouldn’t go into detail on the best way to do that, however, this is how I configured the part for the Tabular Editor step 3:

Although trouble with OLS to date is the fact it didn’t gamble also having Strength BI accounts and that means you had to produce multiple brands of the same statement for several cover roles

For those who publish the brand new report and you may shot the fresh character on the web browser, you’ll see that you get a great “The latest visual provides unrecognized industries” mistake once the dining table regarding the statement uses new Address and you can Bonus industries and that, definitely, an individual cannot access by the OLS:

Safeguards are working as questioned however, wouldn’t it be good if the, in lieu of watching a mistake right here, you could build just one claim that screens the areas if the representative has permission to see them and just screens the name and you will Transformation areas so you can pages who are people in the part with OLS used?

Better, it’s simple to because of the the brand new field variables function. The brand new designed access to profession variables is to allow the stop pages of your own profile to select the areas presented in the layouts using a slicer. Behind the scenes after you perform an area factor a dining table is placed into the dataset which have you to definitely row each job you have opted; it effectively makes the sphere utilized in an artwork study-passionate, and you may have fun with Row Level Cover (RLS) available made for your own profession factor to control which sphere is displayed in your graphic and resolve the situation.

Time for our very own declaration, the next phase is to manufacture yet another community parameter having the columns and you may steps utilized in this new desk:

Notice that brand new “Add slicer compared to that webpage” checkbox is deselected because you don’t require a good slicer with the declaration here. Some tips about what new table created for the field factor turns out:

Then you can change the fresh role that currently possess OLS inside they to use RLS for the community parameter desk, therefore just the rows for the areas which might be anticipate by the latest OLS is actually came back:

It is necessary the OLS and RLS was outlined from the exact same character because of the limit towards the merging OLS and you will RLS out-of additional roles.

It is vital to be concerned that OLS has been securing the newest study right here – new RLS is simply steering clear of the problems.

You to downside associated with the method is one to one thing gets difficult when you yourself have numerous images that require to exhibit different combos out-of shielded and you may non-secure sphere in the a research. There might additionally be a rate punishment: when a graphic spends a field factor an extra DAX query try operate on industry factor desk to select the sphere showing, and while these queries will likely be very quickly all of the day often there is a risk which they escort reviews Waco somehow sluggish your own report down.