Forum Discussion
Security on Power Bi Desktop
Hey,
just to be sure,
I don't understand what you are going to share with your clients?
If it's the pbix file that you created using Power BI Desktop, please be aware that you can't secure the data.
If you sent the PBIX to one of your clients, this client is able to see all the data that is contained in the pbix file.
If you are going to share the report with your clients from within the Power BI service, then you have to consider some other aspects.
But nevertheless, I would create a table user that contains two columns:
- company
create a relationship between the tables
user (one side) -> company (many side) and
company (one side) -> fact (many side)
Create a role that filters the company by email.
Hopefully this gets you started.
Regards
Tom
Hey,
just to be sure,
I don't understand what you are going to share with your clients?
If it's the pbix file that you created using Power BI Desktop, please be aware that you can't secure the data.
If you sent the PBIX to one of your clients, this client is able to see all the data that is contained in the pbix file.
If you are going to share the report with your clients from within the Power BI service, then you have to consider some other aspects.
But nevertheless, I would create a table user that contains two columns:
- company
create a relationship between the tables
user (one side) -> company (many side) and
company (one side) -> fact (many side)
Create a role that filters the company by email.
Hopefully this gets you started.
Regards
Tom
Thank you for your message.
Yes, I would like to share the report with my clients within the Power Bi Service.
Here is a catch of the relationships. Despite my efforts, it still does not work. I think I was wrong about a relationship but I can not figure out which one.
Basically, I only had the table "ImportFresh". I then from this table, created the table "Append" which includes the company and the email requester.
I deleted entries that were duplicate regarding the email requester. Then I created a table from the email requester column and another company table with data from the company column. For these last two tables, duplicates have also been removed.
By testing, it does not work. I retrieve user data only. I would like to retrieve the data regarding all the users that are associated with the company.
I may ask too much, but what am I doing that is not good?
Finally everything goes in order. I ended up finding the mistake, I applied a security role on the wrong table. Thanks for your help.
