one dataset (pbix file) for multiple dashboards

[nwrong]

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

[Anonymous]

How do I perform changes to only one of the reports that links to that dataset but has a diffrent name? Can I publish with the same name? Thank you !

[v-qiuyu-msft · Accepted solution]

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

[tjd]

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.