User unable to see Dataverse table data in Canvas app - Licensing, table permissions and access see fine

(0) Share

Report

Posted on by RandomDept

696

Hi all,

Here are the steps I have taken

1. Create a brand new Environment called - ThisisMyTest

2. No Security group set for the Environment (ie Open access)

3. Create a new Canvas app along with Dataverse table and dummy data (the app simply lists the data in the table)

4. Publish the app

5. Create a new security role 'Dataverse Read' and assigned Read access to USER for the Dataverse table.

6. Add user from AAD as a member of Dataverse Read

7. Assign both Power apps and Power Automate per user licences to the user in step 6 (Premium)

8. Share the app link to the user.

They can open it, but no data is displayed.

Any idea what other permissions I need to check?

Thank you

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Michael E. Gernaey 53,315 Super User 2025 Season 2 on at

Like (1)

Report

hi @RandomDept

Do they have basic user? or did you derive your role from it. I realize you didnt say they see an error, but we need to make sure, so I have my question and then steps I would take. You can have the user trigger Monitor or give them a link that will do it for them.

Monitor overview - Power Apps | Microsoft Learn

a) Is the Connector shared? Do they have privs to use the Connector to access the data, or it is using their privs (for sure?)

For the Data Tables Items, do you just have 'Table Name'?? Since its dataverse?

Also, here is what I would do.
Step 1. Close your App (stop it running)

Step 2. Click the Stethoscope in the Top Right

Step 3. On the bottom click Open Monitor

Step 4. Once Monitor is running go back and run your app

Step 5. Cause your issue to happen

Step 6. Close the app

Step 7. Go to the Monitor and Filter (top right) based on Error, or key word. Go to the line or lines that match this

Step 8. Look at the Response Tab and you will have to expand the Body > and the Header >. Then look at the body to see more details on the error
Do this for each line you find

Step 9. On each line, also check the Code being executed on Tab 2

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
RandomDept 696 on at

Like (0)

Report

@FLMike Thank you so much for such detailed steps to help me troubleshoot.

I can confirm the user has basic access as well as read access.

Running the Monitor resulted in everything showing success. As the app loads, just not the data.

I double checked the app. It is a simple gallery pointed at the Dataverse table (with the fields I want displayed selected).
I can see the table showing in the Data tab and it lists Microsoft Dataverse as the connection.

When looking at the app details, under the Connections it shows 'There are no connections used in this app.'

When I go back into the main environment and click 'Connections' I can see the Dataverse connection under my admin account name. If I click share on it, I only have the option to select Service Prinicpals or Service Principal App IDs.

I think I'm missing something simple 😞 But sounds like the Connection...is not shared. (in the past with apps I have created using Dataverse the connector / sharing was automatic.

Thanks again, greatly appreciated.

Was this reply helpful? Yes No
Michael E. Gernaey 53,315 Super User 2025 Season 2 on at

Like (1)

Report

Hi @RandomDept

Is this part of a Solution or did you Package Export and Import?

Was this reply helpful? Yes No
RandomDept 696 on at

Like (0)

Report

Brand new environment. Brand new app. no imports.
I didn't put it under a solution, just opened the new environment and hit create app

Was this reply helpful? Yes No
Verified answer

Michael E. Gernaey 53,315 Super User 2025 Season 2 on at

Like (1)

Report

Let me as, this...

The data is part of the Dummy Tables or Your own custom one? Just wanted to verify.

Its almost like

1. There is some Row level security so it sees nothing

2. Or they are not part of the BU that has access, even though they have read

If this is a dummy table, try making your own and see if the same problem exists.

If its not a dummy, can you please verify their BU/Org. I know its dumb it should just work

Also, for kicks. just to make sure its not some weird issue with the gallery, add a Text label and do a CountRows(MyTable)

lets see if it sees how many rows are there or not.

Was this reply helpful? Yes No
RandomDept 696 on at

Like (1)

Report

I created a new table in Dataverse when I created the app. Sadly we only have one org so that won't be it.
Will give the row count a shot on Monday, Thank you!

Was this reply helpful? Yes No
RandomDept 696 on at

Like (0)

Report

Thank you so much for the suggestion. After putting in the row count, I at least got an error message from the user account trying to access.

Error when trying to retrieve data from the network: SecLib::CheckPrivilege failed. User: xxxx, PrivilegeName: prvReadcr882_Dataverse_Table_Permission_Test, PrivilegeId: xxxxxx, Required Depth: Global, BusinessUnitId: xxxxxx, MetadataCache Privileges Count: 7777, User Privileges Count: 466

I changed the custom permission 'Read' attribute from User to Organization and it works now. I thought the User permission should have been enough. 🤔.

Was this reply helpful? Yes No
Parvez Ghumra 1,579 Moderator on at

Like (1)

Report

@RandomDept You need to check who is the Owner of the records in the table. User level read permissions, means that users who are assigned that Security Role, can only view records that are owned by themselves or records owned by a Team they are a member of or records shared with them.

Organization level read permissions means that the User who is assigned the Security Role can view all records in the system for that table regardless of who owns them.

Was this reply helpful? Yes No
RandomDept 696 on at

Like (0)

Report

Thank you, All makes sense now.

Was this reply helpful? Yes No