Forum Discussion
PowerBI Desktop Connection Reset during Get Data
1. Are you using the latest version of power bi desktop? if not then please install the latest version
2. are you using the AWS redshift native connector? or Are you using the ODBC connector, if you using the ODBC connector then please consider using the native redshift connector
https://learn.microsoft.com/en-us/power-query/connectors/amazon-redshift
3. I am assuing your AWS source is protected with firewall rules, if yes then make sure your VPN connection is stable.
this error seems be from the AWS source end. You will find mutiple articles in the internet about this error.
If none of the options work, I would suggest you to talk your AWS redshift db management team to check if there is any problem at their end. If they can fix the connectivity from your machine to redshift
Connect on LinkedIn
Did I answer your question? Mark my post as a solution! If I helped you, click on the Thumbs Up to give Kudos.
Proud to be a Super User!
Hi leedb ,
Thank you tharunkumarRTK for the response provided!Has your issue been resolved? If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.
Thank you for your understanding.
1. Are you using the latest version of power bi desktop? if not then please install the latest version
2. are you using the AWS redshift native connector? or Are you using the ODBC connector, if you using the ODBC connector then please consider using the native redshift connector
https://learn.microsoft.com/en-us/power-query/connectors/amazon-redshift
3. I am assuing your AWS source is protected with firewall rules, if yes then make sure your VPN connection is stable.
this error seems be from the AWS source end. You will find mutiple articles in the internet about this error.
If none of the options work, I would suggest you to talk your AWS redshift db management team to check if there is any problem at their end. If they can fix the connectivity from your machine to redshift
Connect on LinkedIn
|
Apologies for the late reply. The notifications ended up in my Spam folder. I installed the latest version of PBI Desktop and that solved the issue. It's interesting how it worked in all our other environments, but not the one. Thank you for the assistance.
