Forum Discussion

veluryram's avatar
veluryram
New Member
8 years ago

cannot connect to odbc using DSN

I am trying to connect from PowerBI to a custom database that we have. We have developed an ODBC driver for our cutsom data source. I have created a DSN for our data source. The DSN  works fine from ...
v-haibl-msft's avatar
v-haibl-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

veluryram

 

Are you able to get data using this DSN in Excel - Get Data successfully?

 

Best Regards,
Herbert

veluryram's avatar
veluryram
New Member
8 years ago

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