The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
"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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
55 | |
42 | |
23 | |
23 | |
16 |