cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mrumy Frequent Visitor
Frequent Visitor

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

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.

1 ACCEPTED SOLUTION

Accepted Solutions
OpenDataLab Regular Visitor
Regular Visitor

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

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!

View solution in original post

1 REPLY 1
OpenDataLab Regular Visitor
Regular Visitor

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

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!

View solution in original post

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (1,271)