Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
"An exception encountered while accessing the target data source."
Has anyone recieved this error in the connections? and resolved this?
Solved! Go to Solution.
Based on your description, this connect works most of the time but occasionally has a refresh issue? Is the timing of the issue difficult to predict, or does it seem to occur most frequently at certain times?
Does the source database have large transformations that it needs to perform sometimes? Could your refresh be failing simply due to the databasing doing something? (i.e. you have an SSIS package running or a user is processing data at certain times)?
Its not uncommon to have random intermittent failures as well. If its always the same source, but not others then its more likely something closer related to that source.
Hi @RossEdwards ,Thanks for your sharing!
Hi @shravanreddy133 ,
I have something to add.
Since the issue occurs intermittently, reviewing the gateway logs might provide more insight into what's happening when the refresh fails.Troubleshoot the on-premises data gateway | Microsoft Learn
You can also provide more information on reporting errors.
I have also found a similar post, please refer to.
Solved: Data Source Credentials Option Greyed Out for ODBC... - Microsoft Fabric Community
How to Get Your Question Answered Quickly - Microsoft Fabric Community
If it does not help, please provide more details.
Best Regards
Community Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @RossEdwards ,Thanks for your sharing!
Hi @shravanreddy133 ,
I have something to add.
Since the issue occurs intermittently, reviewing the gateway logs might provide more insight into what's happening when the refresh fails.Troubleshoot the on-premises data gateway | Microsoft Learn
You can also provide more information on reporting errors.
I have also found a similar post, please refer to.
Solved: Data Source Credentials Option Greyed Out for ODBC... - Microsoft Fabric Community
How to Get Your Question Answered Quickly - Microsoft Fabric Community
If it does not help, please provide more details.
Best Regards
Community Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Based on your description, this connect works most of the time but occasionally has a refresh issue? Is the timing of the issue difficult to predict, or does it seem to occur most frequently at certain times?
Does the source database have large transformations that it needs to perform sometimes? Could your refresh be failing simply due to the databasing doing something? (i.e. you have an SSIS package running or a user is processing data at certain times)?
Its not uncommon to have random intermittent failures as well. If its always the same source, but not others then its more likely something closer related to that source.