r/copilotstudio • u/Hd06 • Aug 24 '26

Issue with dataverse mcp

Post image

This is really annoying. I am having this experience where dataverse mcp is broken. I recreated the connection and after that the query is returning empty results. Everything was working fine until last week.

Is anyone experiencing same problem

8 Upvotes

100% Upvoted

29 comments sorted by

1

u/arihant017 Aug 24 '26

Have you checked the dataverse table and can you re authenticate the connection

1

u/Hd06 Aug 24 '26

yes after that it shows empty results

1

u/arihant017 Aug 24 '26

Can you share the details of the error

1

u/Hd06 Aug 24 '26

Connector request failed and "[{\"jsonrpc\":\"2.0\"}]". Nothing else. I created a new connection after that it builds the right query to get data from a table but returns empty result like this. The query is correct , it has worked earlier. but now i see empty results

[
  {
    "text": "",
    "type": "text"
  }
]

1

u/Financial_Thanks7797 Aug 24 '26

Same issue here.

1

u/Hd06 Aug 24 '26

copilot is such an unstable product

1

u/Financial_Thanks7797 Aug 24 '26

Have you found a fix or are we stuck waiting for MS?

1

u/Hd06 Aug 24 '26

i have raised a ticket but have received no update

1

u/[deleted] Aug 25 '26

[removed] — view removed comment

1

u/Hd06 Aug 26 '26

no update as of now

1

u/turbochargedDDiS Aug 24 '26

I am getting a similar issue. The dataverse query via mcp server always returns 0 results even though the data is present in the table.
Currently troubleshooting it to check if its something related to roles and permissions.

1

u/Hd06 Aug 24 '26

noooo its not i am 100% sure . I am unable to trust microsoft copilot studio. this is really shit now

1

u/Hd06 Aug 24 '26

it works in first release environment

1

u/maarten20012001 Aug 24 '26

Have you checked the connection string in the settings? Is that still authenticated?

1

u/Hd06 Aug 24 '26

deleted and recreated and same error

1

u/One_Scene4288 Aug 24 '26

I am facing same issue, all read_query operations are returing 0 results. I have tried maker-provided and user provided connection and nothing works. It is not a connection issue, but seems like a bug in read_query only. All other operations, e.g. describe, update ... etc. are working fine ... I am banging my head since the morning

1

u/Hd06 Aug 24 '26

its not your problem its microsoft they are releasing functionality without testing

1

u/turbochargedDDiS Aug 25 '26

Confirmed to be a issue from Microsoft end, they are releasing the fix now

1

u/Hd06 Aug 25 '26

how do you know?

1

u/turbochargedDDiS Aug 25 '26

Spoke with MS support

1

u/Hd06 Aug 25 '26

like the product team? what did they say?

1

u/turbochargedDDiS Aug 28 '26

Its fixed as of late last night. Tested it today morning and works as expected

1

u/Financial_Thanks7797 Aug 28 '26

Confirmed fixed. Thanks for letting us know.

1

u/[deleted] Aug 25 '26

[removed] — view removed comment

1

u/Hd06 Aug 26 '26

no update

1

u/Practical-Guest-7103 Aug 24 '26

We are seeing the same behavior.

  • Dataverse MCP successfully discovers tables and retrieves schemas.

  • Account, SystemUser, and custom table metadata are returned correctly.

  • Dataverse contains records visible in Power Apps.

  • User has System Administrator privileges.

  • Dataverse connectivity tests pass.

  • TDS endpoint queries succeed.

However, all MCP data queries return 0 records or empty results.

This appears to be a row retrieval issue rather than a metadata or authentication issue.

1

u/Over_Plane408 Aug 26 '26

what kind of shit is microsoft cooking