Forum Discussion
Data Agent to Fabric SQL DB connectivity issue
Hi Team,
Whenever I am trying to fetch som information from Fabric SQL DB using Fabric Data Agent, I keep getting the following error after few mintues:
Failed to execute step (RAID: ec9e04dc-aaa2-4c68-a2c4-38d3d582e43b). Error: Temporary database issue, please try again
I have admin rights at the Fabric Workspace level and similarly in both Fabric SQL DB and Data Agent. I tried the same after creating a new agent and successfully adding the Fabric SQL db as a source with Specific tables, still keep getting the same error. Even though I have provided example queries to the data agent it doesn't work.
Any Suggestions on what could be the issue?
At least till a month back it was all fine. Even the Fabric SQL DB is working fine when I ran queries.
Figured out it was due to an ownership issue with the SQL Analytics Endpoint. Refer my other post: https://community.fabric.microsoft.com/t5/SQL-database/Fabric-SQL-Endpoint-Issue/m-p/4995932#M607 Closing this thread. Thanks!
2 Replies
Figured out it was due to an ownership issue with the SQL Analytics Endpoint. Refer my other post: https://community.fabric.microsoft.com/t5/SQL-database/Fabric-SQL-Endpoint-Issue/m-p/4995932#M607 Closing this thread. Thanks!
Hi AyusmanBasu0604 ,
If you got blocked on this, please consider raising a support ticket for further assistance.
To raise a support ticket for Fabric and Power BI, kindly follow the steps outlined in the following guide:How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn
Thanks,
prashanth