How to change the query geenrated by Power Bi?

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

0 REPLIES 0

Helpful resources

Announcements

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

Check out the September 2025 Power BI update to learn about new features.

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.