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

[GMichaud]

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 : 

Thank you for your time!

[lbendlin]

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

[GMichaud]

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.

[lbendlin]

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.

[GMichaud]

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

[lbendlin]

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 .