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

RLS outside cube

Hello guys,

I'm having a problem here ... a big one.

Currently I have several cubes, each company that is my client, contains their access rules (RLS), the problem is that every improvement I make, I have to  on each cube, due to the RLS of each client.

When working as a developer(Power BI Developer), could I work on only one cube and later send RLS information to each environment?

How could I do this?

Today, any implementation becomes VERY laborious.

4 REPLIES 4
Super User
Super User

Re: RLS outside cube

Are you missing a word, you have "I have to  on each cube". You have to what on each cube? Can you describe this a little better in terms of the issues you are facing?


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Highlighted

Re: RLS outside cube

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 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.

Example.png

 

 

Re: RLS outside cube

Can someone help me with that?

Moderator Eric_Zhang
Moderator

Re: RLS outside cube


@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 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.

 


@brunozanoelo

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.

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 237 members 2,174 guests
Please welcome our newest community members: