cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
Alex_t1
New Member

Replacing transaction values with null where the data doesnt belong to the user

Hi 

 

Apologies if this has been covered in another post.

 

I am trying to find a way in which the fact table isn't filtered using RLS and instead show a null transaction value but keep the attribute data. The reason being, employees need to see all transactions but only need to see the values of those transactions if it belongs to them. I'd also want to scale this up through managers too. 

 

fact table:

fact table.PNG

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

dim table:

dim table.PNG

 

 

 

 

 

 

 

 

 

 

 

 

 

John Smith (IM) can see:

Im view.PNG

 

 

 

 

 

 

 

 

David Davis (BDM) can see:

BDM view.PNG

1 REPLY 1
croberts21
Responsive Resident
Responsive Resident

We are struggling with a similar issue. To use RLS we would have to buy a PBI license for each of 25 people that would use a report and we are not ready for that.

 

But for your needs, somehow PBI needs to get the current employee key without asking for user input, then use a formula for your "Value" column which I will rename "Myvalue" below. And "Currentkey" is the Employee Key that PBI finds for the current user. 

Myvalue=IF(Currentkey=[Employee Key],Value,"")

 

So if the Currentkey is the same as [Employee Key] then show the real Value, otherwise show a blank string.

 

We have done a workaround with a PBI report and a PBI Pagination Report where we go through a loop of people, make a report just with their data, and email a spreadsheet of the data to them once a week. 

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors