Forum Discussion
Permissions required for Microsoft SQL Server connection
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.
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
3 Replies
yasuo , No I do not think sysadmin is required. We are working with users having access to the limited schema/databases.
Thanks for the reply.
Can you please tell me what access rights you are giving.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
