DataConnectors
DataConnectors copied to clipboard
Parameter binding still enabled after setting SQL_API_SQLBINDPARAMETER = false
I am using samples\ODBC\SqlODBC as my project template. In line 62 of SqlODBC.pq, Config_UseParameterBindings is set to false, thus these lines (287 - 289) should set SQL_API_SQLBINDPARAMETER to false as well:
SQLGetFunctions = [
SQL_API_SQLBINDPARAMETER = false
]
However, Power BI still sends me query with parameter binding, e.g.
select top 501 "Year" from ( select "Year", "C1", case when "C1" is not null then { fn convert("C1", SQL_DOUBLE) } else ? end as "C2", case when "C1" is null then ? else ? end as "C3" from ( select "Year", "Year" as "C1" from "GO Sales (query)"."Sales (query)"."Time" ) as "ITBL" group by "Year", "C1" ) as "ITBL" order by "ITBL"."C2", "ITBL"."C3"
I am sure my .mez is deployed correctly because every other changes I made will take effect in Power BI.
My Power BI Desktop build is: Version: 2.58.5103.501 64-bit (May, 2018)