Forum Discussion
Solved
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 li...
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
yasuo , No I do not think sysadmin is required. We are working with users having access to the limited schema/databases.