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

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
Jeanxyz
Impactful Individual
Impactful Individual

What does ReadData permisison mean?

According to MS documentation,  if we only want to share one table in the data warehouse with another user, we should first give the user ReadDate permission to the warehouse (only read, not readAll SQL endpoint or readAll Spark endpoint), then give the user permission to the table via SQL grant select command. 

 

So below are my questions:

 

1. if the same user connects to the warehouse via Power BI Desktop using sql connection, can he import the whole warehouse?

 

2. if the same user connect to the data warehouse via SSMS using sql connection, can he view the whole warehouse?

 

This question is really critical and I have read lots confusing documentation from Microsoft, please kindly do some test before answering! Thanks a lot! As I only have a free Azure Account, I can't run the test myself.

 

 

1 ACCEPTED SOLUTION
Thomaslleblanc
Super User
Super User

1. no, ReadData just lets the user connect to the database like SQL Server

2, No

 

You can test this with a new user that you have password for and setup with your infrastructure ro security team

View solution in original post

2 REPLIES 2
NandanHegde
Super User
Super User

You can explicitly grant access on individual tables to the user via TSQL query ::https://community.fabric.microsoft.com/t5/Data-Warehouse/How-to-grant-access-for-specific-tables-to-...

 

via granular permission rather  ReadData permission




----------------------------------------------------------------------------------------------
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
Thomaslleblanc
Super User
Super User

1. no, ReadData just lets the user connect to the database like SQL Server

2, No

 

You can test this with a new user that you have password for and setup with your infrastructure ro security team

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Fabric Update Carousel

Fabric Monthly Update - September 2025

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

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.