Power Platform Community Forum Thread Details

Hi,

I have an Access report receiving data from a linked Dataverse table. Although my users can see the data without any issues (i.e. via Power Apps), when launching the report they get this message error:

Here’s some additional information:

As the system administrator, I can run the report and see the data from the Dataverse table
The settings for security role the table is attached to are Read: Business Unit and Write: Business Unit
The users in question belong to the BU and can normally see the data in the table i.e. via Power Apps
The users can perform all actions in the Access file and see all other data (i.e. coming from linked SharePoint lists) except for the contents of the Dataverse table
The users are logged into Access with the same account they use to access Dataverse and Power Apps.

Thank you for any help you can provide.

Categories:

Microsoft Dataverse with Power Apps

Hi @Salv,

When you say the users can access, the data normally in Power Apps, is it a Canvas App or Model Driven? Is there additional data on the Access form that are not on the Power Apps?

You'll have to try and narrow the issue down to see if it is security role related or something else.

Can you try creating a simple Access form with just a couple fields on a single table you know they have access to and see if the issue persists? If they can access, then it's clearly a missing permission..

If that still fails, you might need to capture network traces from their machine via Fiddler or equivalent tool and inspect the failed HTTP responses to determine the cause.

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.