Data Agent to Fabric SQL DB connectivity issue

[AyusmanBasu0604]

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.

[AyusmanBasu0604 · Accepted solution]

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! 

[v-prasare]

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