Forum Discussion

Guustc's avatar
Guustc
Icon for Helper I rankHelper I
10 years ago

Multiple reports in a single dataset withPowerBI Desktop

I have single .pbix file with a datamodel and dataset. I have designed some reports for my collegue with this dataset and now i want to build a dashboard for the CEO.

 

Of course, this dashboard for the CEO is much more detailed and consist of some data that may not be seen by my collegues.

When i now share a dashboard with my collegue's, they can see all the reports in this pbix file.


I can build my dashboard in the powerbi.com service, but then i cannot add measures and thats essential while building a new dashboard.

 

Is there no other option than to copy this pbix file and make a second pbix file with the other dashboard? When there are some changes in the datamodel i need to update both in that way.

Need Help

1 Reply

  • ankitpatira's avatar
    ankitpatira
    Icon for Community Champion rankCommunity Champion
    10 years ago

    Guustc You can use single pbix file for both the reports. Once published in power bi service you need to implement row level security (RLS) and using that you can control access to data within reports so your colleagues can only see certain data in reports while CEO can see everything. Just follow this blog post on how to implement RLS.