Forum Discussion

Daan_vanRiel's avatar
Daan_vanRiel
Regular Visitor
1 month ago
Solved

Fabric Data Agent error user, help!

Hi everyone,

I've created and published a Fabric data agent connected to a Power BI semantic model.

My fellow developers and I can successfully ask questions in both Fabric and Microsoft 365 Copilot. However, one test user consistently receives an error in both environments, using the same questions that work for us.

In Fabric, the error is: "An error occurred. Please try again or ask a new question below."

Expanding the response only shows the same message. In M365 Copilot, the agent reports that the data service is unavailable and it cannot access the underlying dataset.

We have confirmed that the published agent is shared with him and that he can open it. He has Read permission on the underlying semantic model, his RLS access is configured, and he can view data in existing reports connected to that exact model. His account is also allowed to use Fabric Copilot.

The relevant differences are that he has no workspace role in the workspace hosting the agent and only has Read access, while the developers have broader permissions.

According to the following documentation, Read permission on the semantic model should be sufficient, and workspace access should not be required for interaction through a data agent: https://learn.microsoft.com/en-us/fabric/data-science/data-agent-sharing

Is an additional permission or setting required for users accessing a published agent through item-level sharing? Are there any known issues with this scenario?

Where can we retrieve a more detailed error or correlation ID? The current message does not explain which part of the request is failing.

Thanks!

  • Daan_vanRiel​ 

    Per Microsoft's docs, Read access on the underlying Power BI semantic model should be enough for a user to work with a Fabric Data Agent — workspace access isn't a stated requirement. Since this user can already open the semantic model and its reports, and RLS is behaving correctly for them, I don't think we're looking at a basic model-permission gap.

    So before touching anything permanent, here's the plan:

    1. Don't jump to granting Workspace Viewer. If we do add it and that resolves the issue, that's useful diagnostic signal — it'd point to an item-level access problem rather than a semantic-model one. But it should be a test, not a fix we leave in place.
    2. Reproduce it in Fabric directly first. Have the user ask a simple question there, outside of Copilot. If it fails in Fabric too, we know this isn't a Microsoft 365 Copilot-specific problem.
    3. Republish the Data Agent once we've confirmed the semantic model and agent config are up to date — just to rule out a stale publish.
    4. Pull the Data Agent's diagnostics/run details to see exactly where it's failing: auth, semantic model access, query generation, DAX execution, or RLS.
    5. Check Fabric capacity and service health around the exact time of failure, in case it's environmental rather than permissions-related.
    6. Log the details so we have them ready for Microsoft Support if needed: timestamp, user UPN, Data Agent ID, semantic model ID, the exact question asked, and any Request/Activity/Correlation ID.

    Bottom line: the user's setup looks correct per Microsoft's documented model. The right next step is controlled diagnostic testing — not assuming Workspace Viewer is a required fix.

    If this helps, ✓ Mark as Kudos | Help Other

4 Replies

  • Daan_vanRiel​ 

    Per Microsoft's docs, Read access on the underlying Power BI semantic model should be enough for a user to work with a Fabric Data Agent — workspace access isn't a stated requirement. Since this user can already open the semantic model and its reports, and RLS is behaving correctly for them, I don't think we're looking at a basic model-permission gap.

    So before touching anything permanent, here's the plan:

    1. Don't jump to granting Workspace Viewer. If we do add it and that resolves the issue, that's useful diagnostic signal — it'd point to an item-level access problem rather than a semantic-model one. But it should be a test, not a fix we leave in place.
    2. Reproduce it in Fabric directly first. Have the user ask a simple question there, outside of Copilot. If it fails in Fabric too, we know this isn't a Microsoft 365 Copilot-specific problem.
    3. Republish the Data Agent once we've confirmed the semantic model and agent config are up to date — just to rule out a stale publish.
    4. Pull the Data Agent's diagnostics/run details to see exactly where it's failing: auth, semantic model access, query generation, DAX execution, or RLS.
    5. Check Fabric capacity and service health around the exact time of failure, in case it's environmental rather than permissions-related.
    6. Log the details so we have them ready for Microsoft Support if needed: timestamp, user UPN, Data Agent ID, semantic model ID, the exact question asked, and any Request/Activity/Correlation ID.

    Bottom line: the user's setup looks correct per Microsoft's documented model. The right next step is controlled diagnostic testing — not assuming Workspace Viewer is a required fix.

    If this helps, ✓ Mark as Kudos | Help Other

  • v-aatheeque's avatar
    v-aatheeque
    Icon for Community Support rankCommunity Support

    Hi Daan_vanRiel​ 

    Following up to confirm if the earlier responses addressed your query. If not, please share your questions and we’ll assist further.

  • v-aatheeque's avatar
    v-aatheeque
    Icon for Community Support rankCommunity Support

    Hi Daan_vanRiel​ 

    Have you had a chance to look through the responses shared earlier? If anything is still unclear, we’ll be happy to provide additional support.

  • ShivekMaharaj's avatar
    ShivekMaharaj
    Icon for Community Champion rankCommunity Champion

    Hi Daan_vanRiel​,

    Based on Microsoft’s current documentation, I would not add Workspace Viewer as the next permanent fix.

    Microsoft now states explicitly in the Fabric data agent sharing and permissions documentation that for a Power BI semantic model:

    • Read permission is sufficient to query it through a Fabric data agent.
    • Build permission is not required.
    • Workspace membership is not required.
    • RLS and CLS continue to apply.


    So from what you described, the user should already have the minimum documented permission if they have Read on the semantic model and the published data agent has been shared with them.

    I would therefore isolate where the failure actually occurs.

    First, have the affected user open the published data agent directly in Fabric and ask exactly the same question that works for the developers.

    If it fails there as well, I would focus on Fabric/data-source access rather than Microsoft 365 Copilot.

    I would then verify that the agent does not use any additional data source beyond the semantic model.

    Microsoft’s permission guidance says users need access not only to the data agent itself, but also to every underlying data source used by that agent.

    So even if the semantic model permissions are correct, another Lakehouse, Warehouse, KQL database, ontology, or other connected source could still cause the query to fail.

    I would check in this order:

    1. Confirm the user has access to the published version of the data agent.
    2. Confirm Read permission on the Power BI semantic model.
    3. Confirm the exact user is included correctly in the RLS role.
    4. Verify every other data source connected to the agent, if any.
    5. Test the same question directly in Fabric as that user.
    6. Only after that, test the same published agent in Microsoft 365 Copilot.


    I would not treat Workspace Viewer or Build as required permissions here because that would conflict with Microsoft’s documented least-privilege model for Fabric data agents.

    If temporarily granting Viewer makes the problem disappear, I would capture that as evidence for Microsoft Support rather than leaving the broader permission in place.

    At that point I would provide Microsoft with:

    • affected user UPN
    • data agent item ID
    • semantic model ID
    • exact question that fails
    • timestamp
    • whether it fails in Fabric, Microsoft 365 Copilot, or both
    • any correlation/session ID available


    That should help determine whether this is a permission-resolution issue or a service-side problem.

    AI-assisted drafting: AI was used to help structure and phrase this response. I reviewed and validated the technical content before posting.