How to change the query geenrated by Power Bi?

[dacopan]

Hi friends...

Currently we are using dremio connector and DB2 connector...

When power bi generate a query use where cast("C1" as WVARCHAR) = 'AÑO' that causes a error because dremio not support this type of WVARCHAR, 

I'll try to create a custom connector, that rewrite this query, based on https://github.com/microsoft/DataConnectors 

Can you tell me guide to make that?

We only want to remove this WVARCHAR or change to NVARCHAR