Need help on multi tenancy

[AjithPrasath]

Hi ,

  Initially we created the reports and embedded in our application . Currently, what we have to do is multi tenancy. As of now, we have 50 customers and in future the numbers can grow. Each 50 customers will have seperate data with the same data structure. What we have to do is if the user from different company logged in the application - they have to see the data from their company alone. Each company will have seperate database and we can't combine into one. Please suggest the ways to implement . Thanks in advance.

[Selva-Salimi]

Hi @AjithPrasath,

Here’s a suggested approach:

1. Create a Combined Data Model. Instead of keeping each customer’s data in separate datasets, you can combine the datasets into a single model by adding a dimension table that includes a list of companies and their associated data. This table will act as a reference for filtering the data based on the logged-in user.

-Dimension Tables:
- Create a dimension table that lists all the companies.
- User Dimension: Create a dimension table that lists users and their associated companies. 

Establish relationships between your company dimension, user dimension, and your data tables. This will ensure that each dataset is properly linked to the respective company and user. and then define Roles for Row-Level Security. You can use functions like `USERNAME()` or `USERPRINCIPALNAME()` to identify the current user. (you might create a role with a DAX filter like: [CompanyID] = LOOKUPVALUE('UserDimension'[CompanyID], 'UserDimension'[Username], USERNAME()) ).
This filter will ensure that users only see data corresponding to their associated company.

If this post helps, then I would appreciate a thumbs up  and mark it as the solution to help the other members find it more quickly. 

[v-rzhou-msft]

Hi @AjithPrasath ,

According to your statement, I think your requirement is to hide specific tables or columns from report viewers. 

Here I suggest you to try OLS.

For reference:

• Object-level security (OLS) OLS enables you to hide specific tables or columns from report viewers. You can also secure sensitive object names and metadata to prevent them from being discovered.

You can embed a report that uses object-level security .

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AjithPrasath]

Hi @v-rzhou-msft ,

  I don't need to hide the tables or columns. What I need is to implement multi tenancy- based on the customer I need to show the data. How to dynamically change the dataset credentials in the report so that only the specified user will see the data. Thanks in advance.