Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I set up a report so viewers can create a report, Is it possible to make a built-in filter on all pages or in one page so that it automatically appears when creating a report?
Solved! Go to Solution.
Hi , @ZholboldyA
According to your description, you make a report and you want to make the other people show different data when they create a report based on your dataset. Right?
If this , you can create RLS in your dataset.Row-level security (RLS) with Power BI can be used to restrict data access for given users. Filters restrict data access at the row level, and you can define filters within roles. In the Power BI service, members of a workspace have access to datasets in the workspace. RLS doesn't restrict this data access.
For more information, you can refer to:
Row-level security (RLS) with Power BI - Power BI | Microsoft Learn
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi , @ZholboldyA
According to your description, you make a report and you want to make the other people show different data when they create a report based on your dataset. Right?
If this , you can create RLS in your dataset.Row-level security (RLS) with Power BI can be used to restrict data access for given users. Filters restrict data access at the row level, and you can define filters within roles. In the Power BI service, members of a workspace have access to datasets in the workspace. RLS doesn't restrict this data access.
For more information, you can refer to:
Row-level security (RLS) with Power BI - Power BI | Microsoft Learn
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
when the viewer creates a report, this filter is not saved
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
>>Select Slicer >> go to view tab >> click sync Slicer >> Right side Sync slicr add and sync with all pages .
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
92 | |
82 | |
63 | |
62 | |
58 |
User | Count |
---|---|
159 | |
115 | |
103 | |
75 | |
66 |