Reply
arkiboys2
Helper IV
Helper IV

access readyonly datalake

hi,

not sure where exactly to post this question and so I hope it is ok to post it here

using the fabric data factory, I have populated lakehouse with a table

Now in the lakehouse I would like to give readonly access to a user to select * from table

How can I give readonly access to the user and furthermore, how is it possible to give readonly access to the table?

thank you

1 ACCEPTED SOLUTION
NandanHegde
Super User
Super User

NandanHegde_0-1717731867230.png

You can create a custom role :

NandanHegde_1-1717731918833.png

and select specific tables




----------------------------------------------------------------------------------------------
Nandan Hegde (MSFT Data MVP)
LinkedIn Profile : www.linkedin.com/in/nandan-hegde-4a195a66
GitHUB Profile : https://github.com/NandanHegde15
Twitter Profile : @nandan_hegde15
MSFT MVP Profile : https://mvp.microsoft.com/en-US/MVP/profile/8977819f-95fb-ed11-8f6d-000d3a560942
Topmate : https://topmate.io/nandan_hegde
Blog :https://datasharkx.wordpress.com

View solution in original post

4 REPLIES 4
NandanHegde
Super User
Super User

NandanHegde_0-1717731867230.png

You can create a custom role :

NandanHegde_1-1717731918833.png

and select specific tables




----------------------------------------------------------------------------------------------
Nandan Hegde (MSFT Data MVP)
LinkedIn Profile : www.linkedin.com/in/nandan-hegde-4a195a66
GitHUB Profile : https://github.com/NandanHegde15
Twitter Profile : @nandan_hegde15
MSFT MVP Profile : https://mvp.microsoft.com/en-US/MVP/profile/8977819f-95fb-ed11-8f6d-000d3a560942
Topmate : https://topmate.io/nandan_hegde
Blog :https://datasharkx.wordpress.com

hi,

I see these tables as disabled and when I click on th eexclamation mark next to each of these tables, it says I have to set permissions at destination.

Currently the power bi is pointing to the fabric semantic model.

Hi @arkiboys2 
As mentioned by @NandanHegde you can create a new role assignment as follows:

vnikhilanmsft_0-1718035596201.png


Hope this helps.

jwinchell40
Super User
Super User

@arkiboys2 - Take a look at this article, it covers securing the SQL Side of OneLake with your standard SQL Permissions:

https://learn.microsoft.com/en-us/fabric/data-warehouse/sql-granular-permissions

 

This article is also a good one that goes through setting permissions in OneLake as well:

https://learn.microsoft.com/en-us/fabric/onelake/security/data-access-control-model 

avatar user

Helpful resources

Announcements
MarchFBCvideo - carousel

Fabric Monthly Update - March 2025

Check out the March 2025 Fabric update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)