#Manage Users

To get data fetched by the data service in Tableau and Power BI, complete the following steps to grant access to users to the SQL Server database or OData feed first:

1. Click Data service in the left navigation.

2. On the Data service page, click the More commands button on the upper right corner of the corresponding data service tile. Then select Manage users.

3. Click the corresponding tab and take the following actions according to different endpoints:

   • Grant access to users to the SQL Server database:

     1. On the SQL tab, click Add users.

     2. In the Add users panel, click Add to add a user.

     3. Enter a username in the text box in the format User1 or User1.Salesforce.

     4. Click Add to add more users. To delete a user, click the Delete icon.

     5. When ready, click Generate.

     When the passwords are successfully generated, copy them for connection immediately. They are not stored and will only be displayed this one time. If you forget the password, you can select the corresponding user on the SQL tab and click Re-generate to regenerate a password. You can also click Delete to delete the user.

   • Grant access to users to the OData feed:

     1. On the OData tab, click Add users.

     2. In the Add users panel, enter usernames in the text box in the format user1@example.com; user2@example.com.

     3. When ready, click Generate.

     When the access tokens are successfully generated, copy them for connection immediately. They are not stored and will only be displayed this one time. You can check the expiration dates of the tokens on the OData tab. If the token expires or you forget the token, you can select the corresponding user on the OData tab and click Re-generate to regenerate an access token.