Is it possible to set different access permissions within the same published workbook?

[Anonymous]

My PBIX workbook will have 4 tabs. We have 3 separate business groups who need access to only a few out of the 4 tabs.

Group 1 should have access to only tab 1, 2 and 3. 

Group 2 should have access to only tab 2 and 4. 

Group 3 should have access to only 1, 3 and 4. 

Instead of having to maintain 3 separate workbooks each having only the relevant tabs, is it possible to only maintain one workbook, publish it and then give tab level accesses? I have seen some posts that said this is not possible but wanted to check the latest update on this. 

If this is indeed not possible, what is the best way to do this? Each of my workbooks is going to be quite big in size (over 1 GB) and refreshing each on a daily cadence is going to be a little too much. 

Thank you! 

[Idrissshatila · Accepted solution]

Hello @Anonymous ,

so the best way to do this is to do one pbi file for the dataset that is published to service, then create three seperate pbix files that connect to this dataset https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-report-lifecycle-datasets

then give each one access to the report he should acess.

[Anonymous]

thank you @Idrissshatila !!