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?


I have book! Learn Power BI from Packt


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

Proud to be a Datanaut!

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?

Highlighted
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
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 56 members 792 guests
Please welcome our newest community members: