ODBC: Error [HY000] HTTP protocol error. 400 BAD_REQUEST

[SeerData]

Hi all.

Would like to ask for help.

I've been trying to connect my Airtable to Power BI through CDATA. 

I'm adding SQL statement and choosing DirectQuery and this error shows 
"Unable to connect
ODBC: Error [HY000] HTTP protocol error. 400 BAD_REQUEST"

I seek help with my workmate and hers works fine.

I tried some basic troubleshooting like reinstalling both CDATA and Power BI desktop but still getting the same error.

I hope you can help me.

Thank you all 🙂 

[Greg_Deckler]

@SeerData - Probably have to contact CDATA. You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

[amitchandak · Accepted solution]

@SeerData , you are using a custom connector. Need to connect with the developer. But this problem with a database driver. You must ensure that it is installed correctly. Please check the instructions on the driver's page and make sure nothing has been lost.