Copilot Studio

Copilot Studio Agent Not Prompting for Dataverse Permission for One User

(2) Share

Report

Posted on by SP-25060646-0

Hi everyone,

I have created an agent in Microsoft Copilot Studio that fetches data from Dataverse.

The agent is working correctly for most users. However, I’m facing an issue with one specific user:

The agent is able to retrieve Dataverse data for other users.
For this particular user, the agent does not prompt them to grant/allow permission to access Dataverse.
Instead, it directly responds with “No such details found in Dataverse.”
The same query/data works correctly when tested with other users.

I have checked the agent configuration and Dataverse connection, but I’m not sure why the permission/authorization prompt is not appearing for this user.

Could anyone please help me understand:

Why would Copilot Studio skip the Dataverse permission prompt for a specific user?
What user-specific permissions, security roles, or connection settings should I check?
Is there a way to reset or re-trigger the Dataverse authorization for that user?
Could this be related to Dataverse table permissions, sharing, environment access, or the user's connection?

Any suggestions on how to troubleshoot this issue would be greatly appreciated.

Thanks in advance!

Categories:

Building Copilot Studio chatbots in Microsoft Teams

All responses (7)

Answers (0)

Sort by

André Arnaud de Cal... 738 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi,

This might be related to the permissions of the user in Dataverse. Can you check if this user has other roles assigned compared to the users where it is working? For the assigned roles, does the user have access to the table(s) used by your agent?
SP-25060646-0 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, the user has access to the Dataverse table. When the user manually navigates to Dataverse, they can access the table and view all the required data without any issues.

The issue occurs only when accessing the same data through the Copilot Studio agent. The agent is unable to retrieve the data for this particular user and returns “No such details found in Dataverse.”
Suggested answer

Valantis 7,545 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @SP-25060646-0,

The key clue is that the prompt doesn't appear for this user while it does for others.

That means this user already has an existing Dataverse connection registered from a previous session. The agent skips the prompt because it thinks it's already connected, but the data comes back empty.

Two things to check:

1. Stale or broken connection: the user may have a cached connection that authenticated successfully but is now returning no data. Have the user go to https://make.powerapps.com > Connections, find any Dataverse connections listed there, delete them, then interact with the agent again. This forces the agent to prompt for fresh authentication.

2. Row-level security: the user has table access but may only see records they own or that are in their Business Unit. If the records being queried are owned by other users or different BUs, the user would get an empty result even though they can access the table. Check the user's Business Unit in PPAC and compare with the record ownership of the data the agent is querying.

Start with option 1 (delete existing connections) as it's the quickest to test.

Best regards,

Valantis

✅ If this helped solve your issue, please Accept as Solution so others can find it quickly.

❤️ If it didn’t fully solve it but was still useful, please click “Yes” on “Was this reply helpful?” or leave a Like :).

🏷️ For follow-ups @Valantis.

📝 https://valantisond365.com/ 💼 LinkedIn ▶️ YouTube
Suggested answer

11manish 4,802 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

The fact that only one user is affected and the agent works correctly for everyone else makes a global Copilot Studio/Dataverse configuration problem unlikely.

The two strongest possibilities are:

1. The user's Dataverse security/record access differs from other users, or
2. The user has a stale/incorrect Dataverse authentication connection/token.

And because the agent says "No such details found" rather than presenting an authorization error, I would particularly verify whether the Dataverse call is actually succeeding but returning zero records.

The fastest way to isolate it is to run the exact same Dataverse query as the affected user outside Copilot Studio. If they cannot retrieve the record there, fix security/access. If they can, concentrate on the Copilot Studio tool's authentication and query context.
Suggested answer

Haque 4,280 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @SP-25060646-0,

Smart reasoning are already there. To me - "No such details found in Dataverse" - usually comes in when copilot cannot query or index database tables properly.

Common causes involved:

Dataverse Search is Disabled, relevant thread.

Incorrect Authentication Settings, relevant thread.

Knowledge Indexing Status (Preparing, Unknown, or Error instead of Ready),

Data Loss Prevention Policies - need to check if an organizational data policy might be blocking the Dataverse connector or environment communication

I am sure some clues I tried to give. If these clues help to resolve the issue brought you by here, please don't forget to check the box Does this answer your question? At the same time, I am pretty sure you have liked the response!
SP-25060646-0 6 on at

Like
a
(0)

Report
Copy link

Link copied!

@Valantis ,Your suggestion solved our issue. Thanks for that!

Could you also clarify if there is any way for an admin to delete or remove a user's connection within the organization?

This would be particularly useful for Production environments, where it may not always be feasible to provide access to the user to manage their own connection.

Currently, a user can only see and manage their own connections. Is there an admin-level option to manage or delete another user's connection?
Suggested answer

Valantis 7,545 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @SP-25060646-0,

Glad that fixed it pelase mark the answer as"Does this answer your question?" .

Yes, there's an admin level way to do this, it's PowerShell rather than the admin center UI.

Admins can delete another user's connections using the Power Apps Admin PowerShell cmdlets:
Add-PowerAppsAccount
Get-AdminPowerAppConnection -CreatedBy $userId | Remove-AdminPowerAppConnection

This retrieves and deletes all connections created by that user, by their Entra object ID, across environments they have access to.https://github.com/MicrosoftDocs/power-platform/blob/main/power-platform/admin/powerapps-privacy-delete-dsr.md

There's no equivalent in the Power Platform admin center UI, connection management there is user self service only, matching what you've seen. PowerShell is currently the only admin level path.

If you want to target one specific connection instead of all of a user's connections, Remove-AdminPowerAppConnection also takes -ConnectionName, -ConnectorName, and -EnvironmentName directly, so you can scope it to just the Dataverse connection in the environment your agent runs in.https://learn.microsoft.com/en-us/powershell/module/microsoft.powerapps.administration.powershell/remove-adminpowerappconnection

Best regards,

Valantis

✅ If this helped solve your issue, please Accept as Solution so others can find it quickly.

❤️ If it didn’t fully solve it but was still useful, please click “Yes” on “Was this reply helpful?” or leave a Like :).

🏷️ For follow-ups  @Valantis.

📝 https://valantisond365.com/

💼 LinkedIn

▶️ YouTube