Forum Discussion
Custom Connector Creation
I ended up starting over with a fresh copy of the sample code from Microsoft (https://github.com/microsoft/DataConnectors/tree/master/samples/ODBC) and was able to get it working.
Have attempted to troubleshoot this issue myself. What I have ascertained is that it is related to the options used in the ODBC.DataSource function. When I comment out some of the options from the ODBC example code, this error stops appearing. However, at that point, Power BI fails to query fold my data source and I can't do anything except list the values in a table. Can't do very much in the way of filtering or using DAX functions.
I would assume something in this set of options needs to be set correctly based on my driver. While I can find documentation on these options, I am uncertain what resources to peruse in terms of the ODBC driver I am using to figure out which settings are necessary to make the Direct Query functional in Power BI.
Any assistance would be appreciated.