Customize user access to Dataverse

(0) Share

Report

Posted on by Simone_01

Usually when i develop application with other technologies, the datasource is not directly accessible by the user (eg: in .Net application SQL Server as datasource is accessible only through API).
With Dataverse i find no way to access a table in a Power App, without sharing it, and so prevent direct access by the user.

Image i have a table (MyTable1) with some filter that display data in gallery, the user need to have at least read permission over such table to veiw it in Power App.
But if he have such grant, he may directly access the Dataverse bypassing the filter i set up.

So how can in hide the datasource from the user, and only expose filtered data when searched?

----Edited :
if i hide the table to the user, then the user will be also unable to read the table through my PowerApp.
I would like that the table is not directly accessible if not through a Power App, like the SQL Server table is not directly accessible to the user, if not through my front-end .Net application

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

MS.Ragavendar 4,983 Super User 2025 Season 2 on at

Like (0)

Report
@Simone_01,

The approach of Traditional Approach (Windows / Web) based the UI operations will be done in the application however people who having SQL server installed and DB credential using SSMS they used to navigate to the backend and perform some operations but its limited agreed.

However with respect to the dataverse table using you can stop using creating the custom role as shown below.

1. Create a Custom Security Role:

Navigate to the Power Platform admin center.

Go to "Settings" > "Users + permissions" > "Security roles".

Click "New" to create a new security role.

Give the role a descriptive name (e.g., "Limited Access Role").

Save the role.

2. Remove Table Permissions:

Open the newly created security role.

Go to the "Custom Entities" tab.

Locate the table you want to hide.

Uncheck the "Read" privilege for that table.

Save and close the security role.

3. Assign the Security Role to Users:

Go to "Settings" > "Users + permissions" > "Users".

Select the users who should not see the table.

Assign the newly created security role to those users.

Ensure that the users don't have any other roles that grant them access to the table.

However if the user has read / write permission they can able to access the table.

Note : Similar post - https://community.powerplatform.com/forums/thread/details/?threadid=fbe8788a-f437-4e1d-a167-6b86cbb48c6b

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item

Was this reply helpful? Yes No
Simone_01 44 on at

Like (0)

Report

@MSR@08012015 :
I dont think so.
If I hide a table, then the user is unable to access it directly or through a Power App.
I need to make a table only accessible through Power App, like in .Net application in need a SQL Server datasource accessibile only through backend+front-end (and this is just for give you an example of behaviour i like, in my scenario only Dataverse is involved)

Was this reply helpful? Yes No
MS.Ragavendar 4,983 Super User 2025 Season 2 on at

Like (0)

Report

@Simone_01,

In the below approach if the user don't have an access they can't able to view the entities however if the user is having the access to the table they can able to view the table and perform the operations.

I don't think so this will be possible as per your implementation 😔.

Was this reply helpful? Yes No