Applying RLS in an offline PowerBI Desktop environment

[threebyzero]

Hello,

My situation is as follows:

- My office's server is completely offline - no access to PowerBI services

- Each staff has their own user-profile on the offline domain - USERNAME() will return a unique id for each staff

- Staff all use one shared .pbix file to view reports of data imported from Excel files, refreshing the file in PowerBI to view updated data

- I need to apply some restrictions as to what data each staff has access to

Is there a way to use RLS combined with USERNAME() to restrict access to data based on the user-group a staff belongs to for the Desktop version?

This is very different from using PowerBI online service as each staff is opening the .pbix file itself on their own computers.

Thanks!

Ernest Tan

[parry2k · Accepted solution]

@threebyzero RLS Is used at the time of sharing in powerbi service but i don't see there is any solution to apply RLS in desktop. 

[threebyzero]

I was afraid that my suspicions were true. Thanks for confirming! Guess I need to think of another way to restrict access within Desktop.