Forum Discussion
Post PatronRLS outside cube
Post PatronHello, sorry for explaining with little information!
Thanks for your reply right away ...
I will explain in detail the difficulty I face and what I think it is possible to do with power bi development (I will need some help to improve the idea).
What happens:
Currently I work for a company that provides ERP software, we are using Power BI to extract the information from our customers' databases. (The databases are located locally in the client's company).
From the beginning of the project, we wanted to work with the development option, however, we are only starting now, and with that, I need to have the idea well-formed to then program.
Currently we have 3 customers company, and it is giving a lot of work, because each one has its access rules for its respective users, that is, every improvement that is made for a client, we must do it manually for the other pbix and send MANUALLY to the Tenant of each company.
Let me give you an example:
If I make an improvement or correction, company A has different users and rules different from B, since obviously they have nothing to do with each other, but the graphics for both are exactly EQUAL structure, but not with the same data, rls and users.
Company A
- Sales Dataset
- Billing Dataset
-------------------- RLS FOR THE COMPANY A
Company B
- Sales Dataset
- Billing Dataset
-------------------- RLS FOR THE COMPANY B
Company C
- Sales Dataset
- Billing Dataset
-------------------- RLS FOR THE COMPANY C
We are thinking of developing some way to send the pbix files "Sales" and "Billing" all at once, to all tenants.
All companies should use the same charts, but with different data, users and RLS.
I am attaching an image to anyone who knows, to facilitate understanding.
I would be VERY grateful if you would help me.
Microsoft Employee
brunozanoelo wrote:
Hello, sorry for explaining with little information!
Thanks for your reply right away ...
I will explain in detail the difficulty I face and what I think it is possible to do with power bi development (I will need some help to improve the idea).
What happens:
Currently I work for a company that provides ERP software, we are using Power BI to extract the information from our customers' databases. (The databases are located locally in the client's company).From the beginning of the project, we wanted to work with the development option, however, we are only starting now, and with that, I need to have the idea well-formed to then program.
Currently we have 3 customers company, and it is giving a lot of work, because each one has its access rules for its respective users, that is, every improvement that is made for a client, we must do it manually for the other pbix and send MANUALLY to the Tenant of each company.
Let me give you an example:
If I make an improvement or correction, company A has different users and rules different from B, since obviously they have nothing to do with each other, but the graphics for both are exactly EQUAL structure, but not with the same data, rls and users.
Company A
- Sales Dataset
- Billing Dataset
-------------------- RLS FOR THE COMPANY ACompany B
- Sales Dataset
- Billing Dataset
-------------------- RLS FOR THE COMPANY BCompany C
- Sales Dataset
- Billing Dataset
-------------------- RLS FOR THE COMPANY C
We are thinking of developing some way to send the pbix files "Sales" and "Billing" all at once, to all tenants.All companies should use the same charts, but with different data, users and RLS.
I am attaching an image to anyone who knows, to facilitate understanding.I would be VERY grateful if you would help me.
I think you can rely on Power BI Embedded. All data tables shall have an extra company column and you can use the RLS in Power BI Embedded to control the users accessing the reports seeing their own data.