Forum Discussion
one dataset (pbix file) for multiple dashboards
- 9 years ago
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
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.