Manage Roles and View Roles from Excel Spreadsheet

Anonymous 

Don't give up too soon on this.  I promise - you can get this to work.  

Also remember that you have imported the data into Power BI - so the fact that it's from Excel no longer matters - as it now resides in your Power BI file.  

I'll demo with a simple example: 

Let's say I have this table imported in Power BI Desktop

And I want your coworker to only see the data for Florida - you could create a role specific for only Florida like this

When I import this to Power BI service - anyone I drop into this Role - will only be able to see Florida. 

Importantly though - Row Level Security ONLY applies to users in a "Viewer" role of dataset workspace.  - So if you invited your coworker to your workspace as a "Member, Contributor, or Admin" - he/she will not be bound by RLS.

If you still run into issues - import a few screenshots that I can reference.  I'll be able to better guide what needs to be fixed.  

swise001  - thanks for posting this. This was helpful for sure! However, I fiddled with it some more, and found out it was based on the fact that the person was in my workspace, so even when I had her only in an exclusive role, her status as being in my workspace overruled this and that's why the filters weren't working! Such a simple solution....Thank you for your perseverence!