Forum Discussion

Pandadev's avatar
Pandadev
Post Prodigy
2 years ago

Dataflow timeout using ODBC Athena

Hi I have recently been provided with access to an EC2 environment , and I am able to connect to data when in service creating a dataflow using the odbc connector , but there is an issue with timeout...
Need Help
v-weiyan1-msft's avatar
v-weiyan1-msft
Community Support
2 years ago

Hi Pandadev ,

 

You may need to increase the timeout value for the ODBC connection. This can often be done either in the connection string or through the ODBC data source administrator tool.
If you are using a shared gateway, please consider using a dedicated gateway with more resources allocated to it, which might help with timeout issues.
Please ensure that the network connection between your Power BI service and the EC2 environment is stable and has sufficient bandwidth to handle the data transfer without timing out.

In addition, the following link had the similar problem as yours. Please refer to it and see if it helps you.

Solved: ODBC: ERROR [HY000] [Microsoft][BigQuery] (115) Op... - Microsoft Fabric Community

 

Best Regards,
Yulia Yan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.