Forum Discussion

viswaaa's avatar
viswaaa
Helper IV
1 year ago

Power BI Desktop connection to SQL server

Hello All,   One of my organization's Sales team members wants to create a power bi dashboard using our SQL server db. So we created a database called ReportingDB, in that db we created a schema c...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

 

Yes, if you’ve set it up correctly, the Sales team members should only see the views in the Sales schema when they connect to your SQL Server database from Power BI Desktop.

Here's how it works:

  1. Database Access: If you’ve granted the Sales Team AD Group access specifically to the ReportingDB database and restricted access to other databases, they will only see the ReportingDB database when they connect.

  2. Schema Access: Since you’ve given them access to the Sales schema, they will be able to view and query only the views within that schema. They should not see any other schemas unless access is explicitly granted.

  3. Permissions: Ensure that the permissions are set correctly:

    • The Sales Team AD Group should have at least SELECT permission on the views in the Sales schema.
    • They should not have permissions for any other schemas or objects in the database.