Forum Discussion
Helper Ione dataset (pbix file) for multiple dashboards
Currently I have multiple dashboards and I am maintaining one pbix file for each dashboard. The datasets are similar if not the same.
I only want to maintain one pbix file and have multiple dashboards based off the reports in the pbix file, but each dashboard should be filtered to only see a subset of my dataset. What is the best way to do this?
Thanks in advance!
Nate
Hi nwrong,
If I understand it correctly, current datasets contain the same structure, only row records are different. right?
If you want the dashboards display data ignore the user access the dashboard, you can create one dataset to return all data records for all dashboards. Then create multiple reports with filter applied, you can set Visual/ Page/ Report level filter. Then pin the report visual to dashboards.
If you want the dashboards display data filtered according to each user accesses the dashboard, you can create a dataset to return all data records for all dashboards. then apply Row Level Security for the dataset. For more information, please refer to this article: Row-level security (RLS) with Power BI.
Best Regards,
Qiuyun Yu
3 Replies
- tjd
Impactful Individual
I would suggest that you take a look at either row level security (RLS) which could be tied into a user's login, or sharing each unique dashboard with just the users to whom it applies.
v-qiuyu-msftCommunity Support
Hi nwrong,
If I understand it correctly, current datasets contain the same structure, only row records are different. right?
If you want the dashboards display data ignore the user access the dashboard, you can create one dataset to return all data records for all dashboards. Then create multiple reports with filter applied, you can set Visual/ Page/ Report level filter. Then pin the report visual to dashboards.
If you want the dashboards display data filtered according to each user accesses the dashboard, you can create a dataset to return all data records for all dashboards. then apply Row Level Security for the dataset. For more information, please refer to this article: Row-level security (RLS) with Power BI.
Best Regards,
Qiuyun Yu
