Forum Discussion
Problem on a project/model
Here is how you want to set up your data model:
1. A Company dimension to store company information (company id, company name, etc.).
2. All your fact tables will have a CompanyID to link to the Company dimension I mentioned in #1.
3. You will need a table that shows with user belongs to which company. This table will be used to setup Row LEvel Security. More information on this is here https://docs.microsoft.com/en-us/power-bi/enterprise/service-admin-rls
Your requirement to restrict users so that they can only see their data is achieved using Row Level Security. Your other requirement to identify each company database is achieved by using the company dimension - for example, if you are looking at Sales, you can use company dimension to break down sales by company, etc.
Here is how you want to set up your data model:
1. A Company dimension to store company information (company id, company name, etc.).
2. All your fact tables will have a CompanyID to link to the Company dimension I mentioned in #1.
3. You will need a table that shows with user belongs to which company. This table will be used to setup Row LEvel Security. More information on this is here https://docs.microsoft.com/en-us/power-bi/enterprise/service-admin-rls
Your requirement to restrict users so that they can only see their data is achieved using Row Level Security. Your other requirement to identify each company database is achieved by using the company dimension - for example, if you are looking at Sales, you can use company dimension to break down sales by company, etc.