Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
I'm not very sure about your problem. You may take a look at dynamic row level security.
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |