Forum Discussion
Permit users to semantic report only
I need to give users access to a report where the data is being fed from another report. However, i dont want to provide them with access to the original report as it contains more sensitive information. I also dont want to trim the data to feed into the 2nd version due to the lenght of time and space it takes up. Any suggestions on best practices that wont take too long to apply?
Many thanks in advance.
Hi Dorset_Steve ,
Greg_Deckler makes a good point.
I have other different approaches for you to try:
The first method is:
You can do this with Row Level Security (RLS).
Define a role that only has access to the data you want to display, restricting access to sensitive data.
For more information about RLS, please see:
Row-level security (RLS) with Power BI - Power BI | Microsoft Learn
The second method is:
You can create a dataflow that contains only the data required for the second report, and the dataflow can restrict access to the underlying data source.
For more information about dataflow, please see:
Introduction to dataflows and self-service data prep - Power BI | Microsoft Learn
Creating a dataflow - Power BI | Microsoft Learn
If you have any other questions please feel free to contact me.
Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
2 Replies
Dorset_Steve That should be the default. You can share the 2nd report and it will read from the semantic model but those users will not have access to the actual report itself that was build and published with that semantic model.
Hi Dorset_Steve ,
Greg_Deckler makes a good point.
I have other different approaches for you to try:
The first method is:
You can do this with Row Level Security (RLS).
Define a role that only has access to the data you want to display, restricting access to sensitive data.
For more information about RLS, please see:
Row-level security (RLS) with Power BI - Power BI | Microsoft Learn
The second method is:
You can create a dataflow that contains only the data required for the second report, and the dataflow can restrict access to the underlying data source.
For more information about dataflow, please see:
Introduction to dataflows and self-service data prep - Power BI | Microsoft Learn
Creating a dataflow - Power BI | Microsoft Learn
If you have any other questions please feel free to contact me.
Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
