Forum Discussion

yasuo's avatar
yasuo
Regular Visitor
4 years ago
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...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    4 years ago

    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's avatar
yasuo
Regular Visitor
4 years ago

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

v-easonf-msft's avatar
v-easonf-msft
Community Support
4 years ago

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