Power BI Desktop connection to SQL server

[viswaaa]

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 called Sales, in this schema we created views for their reporting

and gave this schema access to the Sales Team AD Group.

My question is if we give the server name, they can see only the respected views in the sales schema, right when they connect to our db server from power bi desktop ?

They can't see any other schemas or databases on that server, right?

Could any one please confim on this.

[rahul_rajesh]

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.