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
Finally everything goes in order. I ended up finding the mistake, I applied a security role on the wrong table. Thanks for your help.