Limit user ability to select data from specific tables from SQL database

[mrumy]

good day,

We are planing to cooperate with one company, that will help us building PBI reports for our customers. But we need to limit their access to only specific SQL DB tables. Is that a possibility. we have on-prem SQL and installed gateway server. Connection is made via Desktop client.

[OpenDataLab · Accepted solution]

The best way to accomplish this would be to:

1) Create a new schema in your database

2) Create a series of views over the tables that you want to give them access to (this is a good practice in any case, when building Power BI models, rather hit view than the source tables directly as it abstracts you from the data model)

3) Limit access to the specific users to that scheama or views.

As a note: If the company you are partnering with couldn't help you with a solution to this problem, then maybe you should be looking to partner with someone that could!