Adding New Assigned Table to Security Role

(0) Share

Report

Posted on by CU24110236-0

One of our User keeps getting the "You don't have permission to view this data" Error in our internal Power Apps, even though we've gave them the necessary roles to access the app. After some checking, we found out that the table they can't open has a lookup Table, which was not on the security role's assigned table list.

The thing is, we don't know how to add a new table for the security role since the app is a legacy app, and we weren't the ones developing it from scratch. Guides on the internet keeps saying to use the Custom Entities tab, but we can't find the feature anywhere thus we thought the solution is outdated.

How do we solve this problem?

Thank you in advance!

Categories:

Microsoft Dataverse

Tables

I have the same question (0)

All responses (6)

Answers (0)

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

Like (1)

Report
Adding New Assigned Table to Security Role

@CU24110236-0,

Power Apps → Tables

Open the main table and check the Columns tab.

Find the column with Data Type = Lookup (Make a note of Related Table Name).

Platform Admin Center → Environment → Settings → Security → Security Roles.

Open the role assigned to the user.

Find the lookup table name , Grant at least Read access (usually Local or Basic level is enough) Save the role.

✅ Please click Accept as solution if my post helped you solve your issue and help others who will face the similar issue in future.

❤️ Please consider giving it a Like, If the approach was useful in other ways.

🏷️ Please tag me @MS.Ragavendar if you still have any queries related to the solution or issue persists.

Was this reply helpful? Yes No
CU24110236-0 2 on at

Like (0)

Report

Adding New Assigned Table to Security Role

@MS.Ragavendar Thank you for the reply, but the reason why I want to add new Assigned Table is because the lookup table is not even in the role's assigned table list. So, I can't do the second step.

Was this reply helpful? Yes No
lynfin 17 on at

Like (0)

Report

Adding New Assigned Table to Security Role

Are you able to switch the dropdown below 'Tables' to 'Show all tables', and see Custom Tables once you scroll down? That should allow you to do what you are asking.

Was this reply helpful? Yes No
Suggested answer

Gabriel G. 831 Super User 2025 Season 2 on at

Like (0)

Report

Adding New Assigned Table to Security Role

Hi there,

As @MS.Ragavendar said, you should be able to do it inside the security role's privileges page. As @lynfin mentioned (sorry I post while he was posting I suppose), if you want to add a new table, you need to make sure you set the tables visibility lookup on 'show all tables':

Once you did it, you should be able to search for custom tables.

I hope it helps!

__________________________________________________

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.

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

Like (0)

Report

Adding New Assigned Table to Security Role

@CU24110236-0,

A quick follow-up to see, does the suggestion worked for you or still you were looking for any other approaches or assistance.

✅ Please click Accept as solution if my post helped you solve your issue and help others who will face the similar issue in future.

❤️ Please consider giving it a Like, If the approach was useful in other ways.

🏷️ Please tag me @MS.Ragavendar if you still have any queries related to the solution or issue persists.

Was this reply helpful? Yes No
Suggested answer

VGKolar 8 on at

Like (0)

Report

Adding New Assigned Table to Security Role

When a user gets the “You don’t have permission to view this data” message, it usually means the Dataverse lookup table they’re trying to access isn’t included in their security role. Even if the main table is assigned, lookup navigation requires permissions on the referenced table as well. The reason you cannot find the table in the security role is due to the new Admin Center UI. It only shows assigned or frequently used tables by default, so legacy or older custom tables may not appear in the list.

You can fix this in either of two ways:

1. In the modern UI, open the security role and change the filter from “Show only assigned tables” to “All tables.” Then search for the missing table, grant the required permissions, and save.

2. If the table still doesn’t appear, open the classic interface via Settings → Advanced Settings → Security → Security Roles. The full list of tables (including older custom tables) will show under the Custom Entities/Custom Tables tab. Add the table there and assign the needed privileges.

Once the lookup table permissions are assigned, the user should be able to open the record without the error.

I Hope this helps.

Was this reply helpful? Yes No