cannot connect to odbc using DSN

Herbert, thanks for the response.

I have treid to get into Excel using DSN. I couldn't retrieve the data. From the ODBC trace log, it appears that there is an ODBC interface function that hasn't been implemented in our driver. I will implement that function in our ODBC driver and see if I can retrieve the data.

Just to let you know, this is an ODBC driver we have developed for a custom analytical database of ours.  It works with a couple of other visual data analysis tools. We are trying to make it work with Power BI too. The problem is that with Power BI, I couldn't even get it to connect to our ODBC driver. With Excel, I can see from the ODBC log that our driver seems to be working fine except for the missing function I have mentioned above.

Thanks,

Ram

I am able to get data into Excel successfully using the DSN after updating our ODBC driver. But I am still not able to connecto to the DSN through Power BI. The ODBC trace log doesn't show the call to SQLDriverConnectW() at all.

Any ideas in diagnosing the Power BI generic ODBC connector would be helpful.

Thanks,

Ram