Forum Discussion
Access Issue: User Unable to Query Fabric Data via Copilot Studio Agent
Hi Team,
We are trying to resolve an access issue with a Copilot Studio agent connected to a Microsoft Fabric data agent.
Scenario:
We have a Copilot Studio agent that uses a Fabric-based Data Agent to answer user queries.
Administrators (who have Fabric Admin rights and Power BI Pro licenses) can use the agent successfully.
Standard Users (who have been granted read access to the relevant Fabric workspace but do not have a Power BI Pro license) receive the following error when querying the agent:
"To provide you with accurate and detailed information regarding case 00009, I need to access the connected data system. Please hold on for a moment while I retrieve the relevant details."
Our Configuration:
The Fabric workspace is backed by an F16 capacity.
Users are licensed with Copilot for Microsoft 365.
Users have been assigned the Viewer role on the Fabric workspace and have necessary data-level permissions
Question:
Based on our understanding of the documentation, a Power BI Pro license should not be required for a user to query data through a Copilot agent when the data resides in a dedicated Fabric capacity (F16). The Copilot license and Fabric permissions should be sufficient.
Could you please confirm if this is correct? If a Power BI Pro license is indeed mandatory for this user scenario, could you please point us to the specific documentation that outlines this requirement?
Complete Error Message:
"To provide you with accurate and detailed information regarding case 00009, I need to access the connected data system. Please hold on for a moment while I retrieve the relevant details."
If you have any specific questions or need information on a particular aspect of the case, please let me know!
apologize, but I cannot provide specific details about case 00009 without proper authorization. If you are authorized to access this information, please contact the relevant department or use the official case management system to retrieve the details.
If you need further assistance or have any other questions, please let me know!
Hi anusha_2023
You're correct, BI pro licenses are not required in your current setup.
Here are a few useful links:
Consume a data agent in Microsoft Copilot Studio (preview) - Microsoft Fabric | Microsoft Learn
Fabric Copilot capacity - Microsoft Fabric | Microsoft Learn
Enable Fabric Copilot for Power BI - Power BI | Microsoft Learn
Check the Authentication Mode of the Fabric data agent in Copilot Studio. If it's set to User Authentication, ensure users have access to both the workspace and the underlying data sources.
--------------------------------
I hope this helps, please mark as solved if it does!
kudos always welcome .
Connect with me on LinkedIn
Subscribe to my YouTube channel for Fabric/Power Platform related content!
5 Replies
Hi anusha_2023
You're correct, BI pro licenses are not required in your current setup.
Here are a few useful links:
Consume a data agent in Microsoft Copilot Studio (preview) - Microsoft Fabric | Microsoft Learn
Fabric Copilot capacity - Microsoft Fabric | Microsoft Learn
Enable Fabric Copilot for Power BI - Power BI | Microsoft Learn
Check the Authentication Mode of the Fabric data agent in Copilot Studio. If it's set to User Authentication, ensure users have access to both the workspace and the underlying data sources.
--------------------------------
I hope this helps, please mark as solved if it does!
kudos always welcome .
Connect with me on LinkedIn
Subscribe to my YouTube channel for Fabric/Power Platform related content!
Hi anusha_2023
Just checking in to see if you had a chance to review the previous response?
If you still need assistance, please let us know and we’ll be glad to help.Hi anusha_2023
We’d like to check if you were able to go through the previous response to your issue. Please let us know if you need further clarification we’ll do our best to support you.
Hi anusha_2023
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.
If you have any question relating to the current thread, please do let us know and we will try out best to help you.
Thank you for all your suggestions. We finally made it worked.
