Limit access to a single database on a server

[HW31]

When connecting a power bi, i have to connect to the server, and optionally, a dB. This server has several dBs on it and I was wondering is there a way to limit the access of the pbi file to a single server? Surely once connected, you can access all databases.

[darentengmfs]

@HW31 

To do that you have to state which Database you want to use when connecting to the server.

[GilbertQ · Accepted solution]

Hi there

The first thing is that you would need the permissions to access all the databases.

IF you do have permissions you could access all the databases through a single connection.

For example if your main connection uses a database called: MyFirstDatabase the TSQL Query could be

Select *
from MyFirstDatabase.dbo.table_Name

Now if you wanted to access another database on the same server, where the other database is called "SecondDatabase" you could use the following TSQL Query

Select *
from SecondDatabase.dbo.tableName