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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
GMichaud
Helper I
Helper I

Which minimum permissions are required to be able to see the content of a SQL Server schema

Hello community!

This will be the first time that I will be trying to give access to a user to a schema in SQL Server from Power BI. I initially only gave the SELECT permission, but this doesn't seem to be enough. The end user was able to connect to the SQL Server instance from Power BI Desktop and was able to see the database to which I gave the permission, but once he tried to expand the database, nothing appeared in Power BI Desktop.

Which minimal permissions are required to be able to see the content of a schema from Power BI Desktop? Here is a screenshot of the list of available permissions just in case : 

GMichaud_0-1717612887037.png

Thank you for your time!

5 REPLIES 5
lbendlin
Super User
Super User

my guess would be "View definition".  Power Query does a lot of Meta data querying.

I've tried this to no avail sadly. For the content of a schema to appear, I had to select Control, which seems to be way too many permissions according to this URL GRANT Schema Permissions (Transact-SQL) - SQL Server | Microsoft Learn
Control grants every permissions.

That sounds eerily similar to the issues we have with SSAS data sources where the gateway connection user basically has to be cube admin (and Microsoft flat out telling us they won't fix that).   You can consider raising that concern as a Pro ticket.

I have never done that before. How am I supposed to do that?

If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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