Multiple changes to single PBIX file

Question

Hi,&nbsp;I have a master file where I do company wide reporting. There is a filter "Department" that limits each department to only their financials.&nbsp;I save the PBIX file as three different instances and change the "Report level filter" to 100/200/300 respectively.&nbsp;All three are uploaded as a report to their seperate workspaces (Dept100, Dept200, Dept300). Access control is managed by each employee having access to their online workspace only.&nbsp;The problem is I have to make the changes to the master file three times for each change. This solution is not scalable as more departments are added.&nbsp;The problem: How can I maintain one file and roll it out with filters change multiple times. A script solution or an online workaround is acceptable.&nbsp;&nbsp;Thanks!&nbsp;

v-xuding-msft · Accepted Answer

Hi&nbsp;DieLem&nbsp;,&nbsp;If you want to show the different content for the special users, maybe you could try to use the option of&nbsp; row-level security.&nbsp;If you have to store them as three reports, there is not a good idea to implement it. For Power BI, they are separate.&nbsp;Best Regards,XueIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

Related content

multiple or single semantic model

Attach multiple lakehouse to a single notebook.

Single master PBI report for multiple clients

Single Legend for multiple visuals?

Single Slicer to Filter Multiple Columns