Azure AI Search in Data agents not working

Hi sahinad ,

Thank you for reaching out to Microsoft Community.

When you test Azure AI Search yourself, it runs under your user identity. However, when a Microsoft Fabric Data Agent queries Azure AI Search, it does not use your account. Instead, the request is made using the Microsoft Fabric Workspace Managed Identity (a service principal).
Azure AI Search allows the request, but because the correct identity doesn’t yet have the required access (or cannot read retrievable fields), it may return only the document key instead of actual content. This results in queries appearing to succeed without returning meaningful data.

Locate the Fabric Workspace Managed Identity. Copy the Object ID of the workspace identity. This identity appears as a service principal, not a user.
Grant Permissions to This Identity in Azure AI Search

In the Azure portal: Azure AI Search > Access Control (IAM) > Add Role Assignment

Assign the roles to the Fabric Managed Identity not to your user:

Search Index Data Reader – allows the Data Agent to query indexes
Search Service Contributor – required when using semantic search features

Hope this helps.
Chaithra E.