Forum Discussion

nwrong's avatar
nwrong
Icon for Helper I rankHelper I
9 years ago
Solved

one 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 d...
  • v-qiuyu-msft's avatar
    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