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.