https://community.fabric.microsoft.com/t5/Developer/Custom-Connector-Get-Data-Types-Identifiers-from-ODBC/m-p/3430693#M44452 <P>Hello, community!</P><P>&nbsp;</P><P>I'm currently working on a custom connector using Power Query SDK, addressing some type-mapping issues along the way.</P><P>My connector relies on ODBC, and I'm keen to enhance and resolve specific type-mapping inconsistencies between the ODBC</P><P>driver and Power BI.</P><P>In particular, I'm interested in acquiring the ODBC driver's type mappings, complete with their identifiers, directly within my Power Query code. Essentially, I want to debug or print the types returned by the driver.</P><P>&nbsp;</P><P>While browsing through your GitHub repository, I came across the <A href="https://github.com/microsoft/DataConnectors/blob/master/samples/ODBC/SnowflakeODBC/SnowflakeODBC.pq#L113C38-L113C38" target="_blank" rel="noopener">Snowflake example</A>. It seems to achieve something similar to what I need. Is there a way I can obtain the connector's type IDs and possibly print them within my Power Query code?</P><P>Any guidance on how I can achieve this?</P> Thu, 14 Sep 2023 10:20:58 GMT BentsiLeviav 2023-09-14T10:20:58Z https://community.fabric.microsoft.com/t5/Developer/Custom-Connector-Get-Data-Types-Identifiers-from-ODBC/m-p/3430693#M44452 <P>Hello, community!</P><P>&nbsp;</P><P>I'm currently working on a custom connector using Power Query SDK, addressing some type-mapping issues along the way.</P><P>My connector relies on ODBC, and I'm keen to enhance and resolve specific type-mapping inconsistencies between the ODBC</P><P>driver and Power BI.</P><P>In particular, I'm interested in acquiring the ODBC driver's type mappings, complete with their identifiers, directly within my Power Query code. Essentially, I want to debug or print the types returned by the driver.</P><P>&nbsp;</P><P>While browsing through your GitHub repository, I came across the <A href="https://github.com/microsoft/DataConnectors/blob/master/samples/ODBC/SnowflakeODBC/SnowflakeODBC.pq#L113C38-L113C38" target="_blank" rel="noopener">Snowflake example</A>. It seems to achieve something similar to what I need. Is there a way I can obtain the connector's type IDs and possibly print them within my Power Query code?</P><P>Any guidance on how I can achieve this?</P> Thu, 14 Sep 2023 10:20:58 GMT https://community.fabric.microsoft.com/t5/Developer/Custom-Connector-Get-Data-Types-Identifiers-from-ODBC/m-p/3430693#M44452 BentsiLeviav 2023-09-14T10:20:58Z