Permissions required for Microsoft SQL Server connection

[yasuo]

We will use MS SQL Server as the data source for Power BI Desktop.
What permissions are required for the user to connect to the SQL Server?
I have tested that "sysadmin" is required, but I would like to confirm that this is really the case because it is a powerful permission.

[yasuo]

Thanks for the reply.
Can you please tell me what access rights you are giving.

[v-easonf-msft · Accepted solution]

Hi, @yasuo 

You don't need to assign any role to the service account, 'public' is enough.

Just make sure that the account has basic permissions to access the database.

Best Regards,
Community Support Team _ Eason

[amitchandak]

@yasuo , No I do not think sysadmin is required. We are working with users having access to the limited schema/databases.