Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

View all the Fabric Data Days sessions on demand. View schedule

Reply
Kaycee
Advocate I
Advocate I

Granting Data Access Across Workspaces

Hi all, 

I require confirmation of how security works across workspaces.  

I have 2 workspaces.  Data Workspace and Report Workspace. 
-----------------------------------------------------------------------------------------------------
Scenario 1:  Report/App and Dataset in Same Workspace
In this scenario, the reports are published into an app. The dataset and reports/app are in one workspace.  The users are granted access to the App and are assigned to a role on the dataset.  The users are not granted access to the workspace.  The app works fine. 
-----------------------------------------------------------------------------------------------------
Scenario 2: Dataset in Alternate Workspace
Same as Scenario 1 except the dataset is in a separate workspace. 

However, in this scenario, the access was not sufficient. I had to also to grant view access to the workspace else the user received an error that they didn't have access to the underlying dataset.  I don't want the users to have access to the workspace. 

-----------------------------------------------------------------------------------------------------

Is there a workaround to this? What is the logic?  I really don't want people to have view access to the 'Data' workspace... 

Thank you



3 REPLIES 3
aj1973
Community Champion
Community Champion

Hi @Kaycee 

Scenario 2 is better, but to let users view reports in app you will need to go to the dataset and click on the 3 dots to give permission, a new window will open and from there assign users to the dataset with read only role.

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Thanks kindly @aj1973 for your reply. 

I assume this is different to RLS, which was already applied?  I did click the 3 dots then Manage Permissions. Is this the place where you add the person, remove all 'tick options' before granting permission?

Kaycee_0-1690862696246.png

 

aj1973
Community Champion
Community Champion

Yes.

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors