cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper V
Helper V

RLS for different companies

Hi guys, i`n using power BI for almost 1 year and working with some companies with that, totallizing 40 users in all of them.

The biggest problem that i have is about the RLS of the cubes.... and i need to solve it or i will need another business intelligence tool in the future.

I have one cube who contains data from the sellers, for extract the data, i`n using ODBC and SQL Firebird 2.54 to connect with the database.

The problem is: The same .PBI File is used for all my companies, but each company have their own RLS, for that i need replicate the same .PBI for each company and change the RLS or delete them, this is VERY difficult if you have 5 or more companies! Each time i make one change or a new graphic in that file, i need to create from zero in each .PBI file.

5 companies, 5 times more work. THIS IS RIDICULOUS. Power BI should be better than this. Serious.

Idk how i can turn that more automatically, please, some admin can help me?
I was thinking to go to the power bi embedded, but this will make some custormers unhappy because they cant change the graphs there.

I can`t go to 100 users now because this is too much painful for maintance.

1 REPLY 1
Community Support
Community Support

@brunozanoelo,

 

I'm not very sure about your problem. You may take a look at dynamic row level security.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors