Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I Need to build a project on power Bi, the model needs to be like this image, multi databases, all datas has the same data model, each user can't acess others data, i'd like some options if possible, another thing is, how could i identify each database.
Solved! Go to Solution.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
56 | |
19 | |
18 | |
18 | |
9 |