Forum Discussion

FPerazzo's avatar
FPerazzo
Regular Visitor
2 years ago

This ODBC: [DataSource.Error] keeps popping ;(

This error won´t let me post changes I did in the Power Query Editor

Error de OLE DB u ODBC: [DataSource.Error] ERROR [HY000] [Treasure Data][Presto] (1040) Error with HTTP request, response code: 404.

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi FPerazzo ,

    You can try to follow these steps to find the solution:
    1. Verify the Connection String: Ensure that the connection string used in Power Query to connect to the Treasure Data Presto is correct. A 404 error often indicates that the URL or resource specified in the connection string cannot be found. Review the connection details against the documentation provided by Treasure Data to ensure accuracy.
    2. Check for Service Availability: Sometimes, a 404 error can occur if the service or resource you're trying to connect to is temporarily unavailable. Verify the status of the Treasure Data service to ensure it's operational.
    3. Update ODBC Drivers: Ensure that you have the latest ODBC drivers installed for the Treasure Data Presto. Outdated drivers might not be fully compatible with the latest updates or features of the service.

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